Nested IF with IFERROR

PeggyLang

I have an IF statment that is working fine.

But in many cases it is returning '#INVALID DATA TYPE'. When it returns that I would like the cell to be empty. How do /where do I nest the IF with the IFERROR?

Kelly Moore

Hey @PeggyLane

=IFERROR(IF([Helper1 - Weekday = Monday?]@row = 2, "", "Red"),"")

Kelly

Kelly Moore

Hey @PeggyLane

=IFERROR(IF([Helper1 - Weekday = Monday?]@row = 2, "", "Red"),"")

Kelly

PeggyLang

The Syntax was KILLING me! THANK YOU!!!!