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.

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.