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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How To Have A Cell Be Blank If... 2
Excel formula, sum the value cell and if empty cell left blank 0
"Blank" cells showing unwanted data 4
Sumproduct - Return value as Blank 3
Blank Cell 5
Formula returning a blank cell if answer is zero 7
Dragging with IF-Functions 1
Formatting 0 values to show blank cells 4

Back
Top