If/And/Or Nested formula needed

September 9, 2011 at 13:54:54
Specs: Windows 7
I think I need a nested If/And/Or type of formula, but I can't get it to work. I am trying to get a formula to determine:

If cell "A" is blank and cell "B" is blank, subtrack cell "H" from cell "J", but if cell "A" is not blank, subtract cell "A" from Cell "J", but if cell "A" is blank but cell "B" is not, then subtract cell "B" from cell "J".

Can anyone help??


See More: If/And/Or Nested formula needed

Report •


#1
September 9, 2011 at 15:01:08
If cell "A" is blank and cell "B" is blank, subtrack cell "H" from cell "J",
but if cell "A" is not blank, subtract cell "A" from Cell "J",
but if cell "A" is blank but cell "B" is not, then subtract cell "B" from cell "J".

You have it pretty well proto typed.
This should work for now:

=IF(AND(A1="",B1=""),J1-H1,IF(B1="",J1-A1,J1-B1))

But:
What should happen if BOTH A & B are not Blank?
What should happen if A, B, & H are not Blank?
What should happen if J is Blank?

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question