Multiple IF formula over 2 columns

ChipDAC3

So I have a sheet with 2 columns that have numbers, text or blank. I want a 3rd column to do this, "If column 1 is blank, display A. If column 2 is blank, display B. If both columns 1 and 2 are blank, display C"
How would I write a formula to make that happen?

Jgorsich

Always evaluate from most restrictive to least restrictive:

=if(and(column1@row = "", column2@row=""),"C",if(column1@row="","A",if(column2@row="","B","no blanks")))

Check for both (most restrictive), then check for blanks in each individually (order doesn't matter), then handle it if both aren't blank.

The reason you go most restrictive to least is that if both are blank and you are testing for either individually FIRST, that will flag as true before you get to your "what about both?" test. Obviously, there are other ways to handle this also, but it is in general the best way to address it in my opinion.