Iserror, if, find and

[mi1stormilst]

I have the following formula

=IF(ISERROR(FIND("SCADA",M516)),IF(I516>0,IF(AND(I516=2025),"PD","COM"),"Unknown"),"SCADA")

All I want is the formula to look at an additional cell BS516 for the value of 281 and print PD in the cell. I keep trying to manipulate the existing formula and I am not getting my syntax correct. Any help would be greatly appreciated

 

[AngelJ]

Do you want it to output PD under the same conditions you've specified? Like this?

=IF(ISERROR(FIND("SCADA",M516)),IF(I516>0,IF(OR(I516=2025,BS516=281),"PD","COM"),"Unknown"),"SCADA")

 

[mi1stormilst]

It is still printing Unknown to the cell this formula resides in )-:

 

[AngelJ]

Woops, yeah, I missed a detail there. I'm still taking shots in the dark but does this seem to do what you wanted?

=IF(ISERROR(FIND("SCADA",M516)),IF(OR(I516>0,BS516>0),IF(OR(I516=2025,BS516=281),"PD","COM"),"Unknown"),"SCADA")

 

[mi1stormilst]

THANK YOU! That very well may be working, can you explain how that impacted my AND function in the previous formula?

Woops, yeah, I missed a detail there. I'm still taking shots in the dark but does this seem to do what you wanted?

=IF(ISERROR(FIND("SCADA",M516)),IF(OR(I516>0,BS516>0),IF(OR(I516=2025,BS516=281),"PD","COM"),"Unknown"),"SCADA")

 

[AngelJ]

The AND function actually wasn't doing anything in the original formula because it only had one parameter.

I used the OR function twice so that the last IF function is only reached if column I > 0 OR BS > 0. Then, the last IF function outputs PD if I = 2025 OR BS = 281, otherwise it outputs COM.