Excel Question 1

[shannanl]

I have a formula that subtracts the value of one cell (A1) from another cell (B1). I want to check for a valid number in each cell before attempting the formula. If either does not have a valid number then I want a zero in the cell.

Something like this:

= if isnumber(A1) and isnumber(B1) then SUM(B1-A1) else 0

Of course this forumla does not work. What is the correct syntax for this?

Thanks in advance.

 

[bluedragon2]

=IF(AND(ISNUMBER(A1),ISNUMBER(B1)),B1-A1,0)

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[shannanl]

Excellent, thank you very much.

Shannan

 

[bluedragon2]

My pleasure

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...