Blank cells are treated as 0 in comaprisons so you can have
=IF(B30450,B30-450,IF(AND(B30"",B30426),B30-426,"0"))

"wcurtis" wrote:

I have an IF formula that displays a zero if the number falls between a set
of numbers.
=IF(B30450,B30-450,IF(B30426,B30-426,"0"))
But if no data is found in the reference cell then I want the cell the
formula is in to display 0, how do you do that?
Example would be that B30 is blank, I get a -426.

Thanks in advance.