IFERROR Formula with Conditions on Display on Error

I have an IFERROR formula that is working as is (below), but I need to add a conditional statement to determine what needs to display when there is an error.

If there is an error, AND Column RA Type = "RA Type", then display "Rent to Income Ratio". Otherwise, display "" (blank).

=IFERROR((Rent@row * 12) / [Prev Resident that had RA or Income]@row, "Rent to Income Ratio")

Ideas on how to do that?

Best Answer

  • Toufong Vang
    Toufong Vang ✭✭✭✭✭
    Answer ✓

    Hi, Bethany.

    Try...

    =IFERROR((Rent@row * 12) / [Prev Resident that had RA or Income]@row, IF([Column RA Type]@row = "RA Type", "Rent to Income Ratio", ""))

    The syntax for IFERROR() is IFERROR( this_is_what_you_prefer_be_done, alternatively_do_this )

    Your alternate can be a value or another statement which, in this case, is:

    IF([Column RA Type]@row = "RA Type", "Rent to Income Ratio", "")

    Cheers!

Answers

  • Toufong Vang
    Toufong Vang ✭✭✭✭✭
    Answer ✓

    Hi, Bethany.

    Try...

    =IFERROR((Rent@row * 12) / [Prev Resident that had RA or Income]@row, IF([Column RA Type]@row = "RA Type", "Rent to Income Ratio", ""))

    The syntax for IFERROR() is IFERROR( this_is_what_you_prefer_be_done, alternatively_do_this )

    Your alternate can be a value or another statement which, in this case, is:

    IF([Column RA Type]@row = "RA Type", "Rent to Income Ratio", "")

    Cheers!

  • Bethany Garcia
    Bethany Garcia ✭✭✭✭

    @Toufong Vang that worked perfectly, thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!