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??

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

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History