Forum Discussion

Copper Contributor

Mar 24, 2020

Help with an IF/AND formula please

Hi there, My formula is =IF(AND(P88>0,O88="T1"),P88*data!$E$16,IF(O88="T1.5",P88*data!$E$17,IF(O88="T2",P88*data!$E$18,))) where the first bit says if P88 is greater than zero AND 088 = T1...

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Mar 24, 2020

cowleyp You can wrap your entire formula in an IFERROR statement.

=IFERROR(<formula>,"")

In your case it becomes like this:

=IFERROR(IF(AND(P88>0,O88="T1"),P88*data!$E$16,IF(O88="T1.5",P88*data!$E$17,IF(O88="T2",P88*data!$E$18,))),"")

cowleyp

Copper Contributor

Mar 24, 2020

Riny_van_Eekelen

Hi Riny,

Thanks for your quick and accurate help!

Your suggestion worked perfectly! SOLVED

Thanks