I'm struggling a bit with getting the variable 'price' to 2 decimal places. I've got price set as Dim price As Single but it isn't working with just that. What am I doing wrong? I'd also like to round up the result of Range("D" & x).Value to #.99
Also, as I'm a total rookie I'm struggling to be efficient with my coding and feel this script is a bit long winded. Is there anyway to reduce it down?
Please Login or Register to view this content.
Last edited by DMacSTB; 03-11-2017 at 04:53 PM.
price = Round((Range("R" & x).Value / divider * 1.2) / (1 - (Fee / 100)),2)
Ben Van Johnson
Awesome thanks very much. It appears as 2 decimal places but the value in the cell is still several decimal places. Any idea how to fix that?
I just did a re-test with 2/3 and it shows 0.67, Also I'm not sure what
round up the result of Range("D" & x).Value to #.99
should return, so we would have to see a sample workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks