| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round with IF's
I figured out a formula (below) but then realized that I needed to round the
numbers to two decimals so I tried to add Round into it (which I've never used before). It seems to work except that now the cells that do not have a number in them are showing a #Value error. Can someone please tell me what I am missing? Here's what I have =ROUND(IF(D24="","",IF(E24="",D24-F24,IF(E24=0,D24-F24,(D24*E24)-F24))),2) Thanks in advance. I'm very new to Excell and I'm really enjoying learning it but I think I might have given up a long time ago without this website. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Too many 'if's! | Excel Discussion (Misc queries) | |||
| IF's | Excel Worksheet Functions | |||
| to many 'IF's'?? | Excel Worksheet Functions | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
| How many if's? | Excel Discussion (Misc queries) | |||
Threaded Mode
