Hiten Vakharia
Board Regular
- Joined
- Sep 25, 2013
- Messages
- 66
Hi,
I have come across below forumla, this is for rounding price
Could anyone explain what does this mean
=IF(A3="","",IF(A3<7,CEILING(A3,0.1)-0.01,IF(A3<20,CEILING(A3,0.5)-0.01,CEILING(A3,1)-0.01)))
Thanks
Hiten
I have come across below forumla, this is for rounding price
Could anyone explain what does this mean
=IF(A3="","",IF(A3<7,CEILING(A3,0.1)-0.01,IF(A3<20,CEILING(A3,0.5)-0.01,CEILING(A3,1)-0.01)))
Thanks
Hiten