How do I make a cell appear blank if the value returned by the for

  • Thread starter Thread starter Kara E.
  • Start date Start date
K

Kara E.

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.
 
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)
 
Back
Top