OR IF function?

[Willcy]

I need to check two cells for blanks and report a zero if the cell is blank. If EITHER of the cells are not blank, I need to make a simple computation. I can write the formula for one cell or for the other, but I don't know how to COMBINE the two "IF" statements. In Lotus, I seem to recall a function called "OR_IF", but can't seem to find a way to do it in Excel. Here's the two formulae I need to combine:

=if(a1="",0,c1-d1) OR =if(b1="",0,c1-d1)

If EITHER a1 or b1 is blank, i want to subtract d1 from c1. Can anyone help me with the "OR" function with two embedded "IF" statements?

Thx,
-Willcy-

[ratcat]

G'day

Try this it may work in Lotus

Please Login or Register  to view this content.

[Willcy]

Ratcat, you're the man (or woman)! I took your suggestion, and modified it for my application and NOT ONE error dialogue box filled my screen.

Here's the final equation. (I added the IF TRUE statement of "0" before the ELSE computation).

=IF(OR(C15="",E15=""),0,C15-E15)

Thanks much for the help.

[jjbrown]

I'm trying to get a formula that makes a different calculation based on the text in cell A1. Does anyone have a suggestion on the best way to do this?

If cell A1="Text" then (A-B), or if cell A1="Text" then (C-D), or if cell A1="Text" then (E-F).

[arthurbr]

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.