Is it possible to write an IF statement containing multiple references to 2 other cells?

[Karelia Suite]

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.

[TMS]

Try this:

Please Login or Register  to view this content.

Regards, TMS

[TMS]

See the attached sample workbook:

Regards, TMS

[Karelia Suite]

Absolutely brilliant - thanks a million.

[TMS]

You're welcome.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[Karelia Suite]

Duly done, thanks again.

[gomathi7]

Hi, note the file enclosed with the conditions you specified

Regards
Gomathi