That works, but it evaluates virtually the entire formula before it discovers
there's nothing to do. I would suggest starting with that test so it can
stop right away if there's no value:

=if(B30="",0,IF(B30450,B30-450,IF(B30426,B30-426,"0")))

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Sheeloo" wrote:

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.