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?
Help Article Resources
Check out the Formula Handbook template!