Dear All,
I have a bunch of random products with different prices and I need to round them off to either ending with 45 or 95, whatever is nearest so the marketing department will be happy.
I'm attached the XLS file and would love to see a handy formula to manage this (i.e. fill out the yellow cells in D - I rounded of the prices manually in column C).
Note I don't know VBA.
Product Price Rounded (Manually)
A 11.515 11495
B 4.205 4195
C 4.535 4545
D 17.460 17445
E 4.640 4645
F 5.195 5195
G 16.800 16795
H 4.550 4545
I 5.000 4995
J 11.185 11195
K 3.440 3445
L 3.645 3645
M 11.460 11445
N 2.900 2895
I hope you can help as manual can take a long time with hundreds of productsPrice formula.xlsx
Thx
Alex
Bookmarks