| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using ROUNDDOWN - Help please
I WANT my formula to say:-
If a5 is blank, leave this field blank, otherwise multiply a6 by a7 and round the answer DOWN to 2 decimal places - but I can't get it to work. I tried:- =If(a5="","",rounddown(a6*a7),2) Removing "rounddown" and ",2" makes the formula work (but with too many decimal places). So what am I doing wrong with the rounddown part?? Many thanks in advance. -- -=<BritRaider=- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you nest ROUNDDOWN in an IF formula? | Excel Worksheet Functions | |||
| rounddown | Excel Worksheet Functions | |||
| ROUNDDOWN Excell function | Excel Worksheet Functions | |||
| Rounddown problem... | Excel Discussion (Misc queries) | |||
| Roundup or rounddown | Excel Worksheet Functions | |||
Threaded Mode
