# IFERROR Formula with Conditions on Display on Error

Options
✭✭✭✭

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?

• ✭✭✭✭✭
Options

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!

• ✭✭✭✭✭
Options

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!

• ✭✭✭✭
Options

@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!