formula question

[Landonking]

I have the formula =IF(ISBLANK(N13),K13,Q13*P13*O13).

When the condition is True I return K13. In some cases K13 may be a blank cell. Currently, the formula returns a 0 is K13 is blank. Instead of a 0 I need to just return a blank cell. How do I change this formula so that I get a blank cell when K13 is blank?

Thanks in advance for any help,
Landon

 

[Jonmo1]

Try

=IF(ISBLANK(N13),IF(K13="","",K13),Q13*P13*O13)


Hope that helps.

 

[Landonking]

Perfect... Thanks!!

 

[JackDanIce]

Something perhaps to bear in mind is that if a cell is set to "", it may visually look blank, but if you test that cell with =ISBLANK(A1) the answer will be FALSE because Excel evaluates that cell as containing characters (which just happen to be ones you can't see!)

 

[Jonmo1]

That's a good point Jack..

LEN(cell)=0 is probably a better test for blank.