| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a cell appear blank if the value returned by the for
is zero? The formula I'm using is a reference formula so all the information
I need to use it for is below so I just drag it down. The formula I'm using is: =IF(F18="Purchase Money Second","",(P18-O18)*D18)/100. Once I put all of the data into my worksheet I drag the formula down. Not only does the top cell show a zero but the cells I drag the formula over come back with the #VALUE error, and it tells me that "a value used in the formula is of an incorrect data type. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I make a cell appear blank if the value returned by the for
You have your brackets in the wrong place... You are dividing blank by 100.
Try this... =IF(F18="Purchase Money Second","",((P18-O18)*D18)/100) -- HTH... Jim Thomlinson "Kara E." wrote: is zero? The formula I'm using is a reference formula so all the information I need to use it for is below so I just drag it down. The formula I'm using is: =IF(F18="Purchase Money Second","",(P18-O18)*D18)/100. Once I put all of the data into my worksheet I drag the formula down. Not only does the top cell show a zero but the cells I drag the formula over come back with the #VALUE error, and it tells me that "a value used in the formula is of an incorrect data type. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make #N/A blank if no value is returned | Excel Worksheet Functions | |||
| #Value Being Returned for Blank or Non Zero Value | Excel Worksheet Functions | |||
| #NUM! being returned instead of 0 or blank | Excel Worksheet Functions | |||
| How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
| blank cell returned | Excel Worksheet Functions | |||
Hybrid Mode
