Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Price rounding - exception formula required
At present, I'm using a tried and trusted formula for rounding prices in
Excel (from the G2 cell) to either .50 or .95 as follows: =ROUNDDOWN(G2+0.041,0)+IF(G2-ROUNDDOWN(G2+0.041,0)=0.5,0.95,0.5) I've now been asked if an exception can be made to the formula for prices of 100+ which rounds down to the nearest whole unit, i.e. 101.95 becomes 101, 503.59 becomes 503 and so on. Any help appreciated. Regards Alex McCourty E-mail: |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
Formula for conditional "ifs"? | New Users to Excel |