Forum Discussion
Solved
Excell formula help
Hi all, I would like excell to complete a formula for pricing goods. Could someone kindly advise if the following is possible in one cell's formula or would it need to be over several cells and how...
Replace your existing formula with the following one and let me know if that works for both the scenarios....
=IF(MOD(100,E5)>1,ROUNDUP(E5*2,-1)-1,(E5-1))
Thank you for your reply.
It works for the multiples of 100 but if the value is £44 it gives a completed formula value of £88 not £89?
Replace your existing formula with the following one and let me know if that works for both the scenarios....
=IF(MOD(100,E5)>1,ROUNDUP(E5*2,-1)-1,(E5-1))
- You sir are a genius, thank you so much. That worked a treat!