MULTIPLE IF ISBLANK FORMULA NOT WORKING

[meppwc]

I do not understand why this formula is now working. Once I key it into the cell, if triggers an error asking me if am trying to create a formula.

=IF((ISBLANK(A40)+ISBLANK(I40)+ISBLANK(K40)+ISBLANK(M40)>0,"","DECOMISSION IN AI AND ORACLE")

 

[Fluff]

How about

=IF(OR(A40="",I40="",K40="",M40=""),"","DECOMISSION IN AI AND ORACLE")

 

[Joe4]

Yes, it does that when you have a typo. You have unbalanced parentheses.
Try this:

=IF(ISBLANK(A40)+ISBLANK(I40)+ISBLANK(K40)+ISBLANK(M40)>0,"","DECOMISSION IN AI AND ORACLE")

 

[meppwc]

Worked great, thanks so much

 

[Fluff]

Glad we could help & thanks for the feedback.