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
-
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
-
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!
-
@Toufong Vang that worked perfectly, thank you!
Help Article Resources
Categories
Check out the Formula Handbook template!