This is one solution:
="1 is "&PROPER(TEXT(B244,""))&". 2 is "&PROPER(TEXT(B39,""))&". 3 or
4 is "&PROPER(TEXT(AND(B44.9,B52.4),""))
The formula tests all 4 conditions, since I thought the AND/OR
conditions were not clear. I.e. If 1 or 2 is False and 3 or 4 is False
...
In case you want AND/OR conditions, I would recommend to use CHOOSE.
=CHOOSE(1+(A244)*1+(A39)*2+(AND(A44.9,A52.4))* 3,"1 is False. 2. is
False. 3 or 4 is False","1 is True. 2. is False. 3 or 4......) 7
different solutions
Hope it helped
Ola Sandström
--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread:
http://www.excelforum.com/showthread...hreadid=379045