Thread: How do I make a cell appear blank if the value returned by the for
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kara E. Kara E. is offline
external usenet poster
  
Posts: 1
Default 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.
Reply With QuoteReply With Quote