How to make formula shorter ?

[nur2544]

Dear all,
Is it possible to make the below formula shorter?
CONCATENATE(IF(COUNTIF(A2:D2,"F")>0,"Fail in ",""),IF(COUNTIF(A2:D2,"F")=0,"",COUNTIF(A2:D2,"F"))," ",E2)

[abousetta]

Maybe:

Please Login or Register  to view this content.

abousetta

[nur2544]

Hi,abousetta
you have saved 16 characters. thanks for your time..

[total character of my formula was (105) and your formula is (89)]

[abousetta]

This is called a nested IF statement. There are limitations on the number of nestings you can use (I think 7 in XL03 and 36 in XL07 onwards).

In all cases, glad I could help.

Good luck.

abousetta

P.S. If you are satisfied then mark the thread as solved.

[jeffreybrown]

If I'm reading your requirements right, how about...

=IF(COUNTIF(A2:D2,"F")>0,"Fail in " &COUNTIF(A2:D2,"F"),"")