Hi there,
I am trying to write a logical formula for a spreadsheet and am running into problems. I can get as far as the IF formula for one true and one false. But I would love to get multiple scenarios worked into one cell.
For example, if A1 is X then make A10 Y or if A1 is A make A10 B or IF A1 is X AND A3 is Z then make A10 N.

So I guess I need to make 3 or 4 conditions for one cell.