Hi,
I would like to know if it is possible to write an IF statement that addresses all of the following conditions in one cell:-
If Cell A1 and C1 are both blank, Cell E3 is blank
If Cell A1 contains any numeric value and C1 is blank, Cell E3 is blank
If Cell C1 contains any numeric value and A1 is blank, Cell E3 is blank
If Cell A1 and C1 both contain zero, Cell E3 contains the text "Zero"
If Cell A1 contains any numeric value greater than the value in Cell C1, Cell E3 contains the text "A"
If Cell C1 contains any numeric value greater than the value in Cell A1, Cell E3 contains the text "B"
If Cell A1 contains the same numeric value as C1 (but greater than zero), Cell E3 contains the text "C"
I understand it is possible to do something like this:-
=IF(A1>C1,"A","")&IF(C1<A1,"B","") etc...
But I'm not sure how to address all of the conditions I listed.
Hope someone can help. Many thanks.
Bookmarks