How to make this FALSE blank?

bpflyr

Board Regular
Joined
Nov 7, 2005
Messages
116
I have this formula:

=IF(AND(C11="C560",K11>0,P11>0),IF(SUM(P11-R11)<=0,"",SUM(P11-R11)))

It keeps giving me "FALSE" if there are no values in any of the cells need for the formula. Is there a way to make the cell "" instead of reading "FALSE"?

Thanks in advance?
 

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
Try:

=IF(AND(C11="C560",K11>0,P11>0),IF(SUM(P11-R11)<=0,"",SUM(P11-R11)),"")

Hope that helps!
 

Forum statistics

Threads
1,078,246
Messages
5,339,068
Members
399,276
Latest member
Donjayok

Some videos you may like

This Week's Hot Topics

Top