Help adding Iferror to existing formula

I have the following formula:

=IF(X31<=7,"0-7 Days",IF(X31<=15,"08-15 Days",IF(X31<=30,"16-30 Days",IF(X31<=30,"30+ Days","30+ Days"))))

I am receiving some #N/A results. If I want the #N/A results to read "Inactive Account" how do I add the iferror to the formula?

Thank you.

Try

=IFERROR(IF(X31<=7,"0-7 Days",IF(X31<=15,"08-15 Days",IF(X31<=30,"16-30 Days",IF(X31<=30,"30+ Days","30+ Days")))),"Inactive Account")

That worked man Thanks a bunch!!

You're welcome

Originally Posted by rwmeis

I have the following formula:

=IF(X31<=7,"0-7 Days",IF(X31<=15,"08-15 Days",IF(X31<=30,"16-30 Days",IF(X31<=30,"30+ Days","30+ Days"))))

I am receiving some #N/A results. If I want the #N/A results to read "Inactive Account" how do I add the iferror to the formula?

I cannot figure out why you receiving some #N/A result with that formula. If X31 is blank or contains text the result will be 30+ Days, otherwise the formula will give a correct result.

Maybee you can post a sample of workbook so we can find out the reason of your #N/A's

Originally Posted by Rambo4711

I cannot figure out why you receiving some #N/A result with that formula.

I thought about that too, and concluded that the error must be coming from X31 itself.
Maybe it contains a Vlookup.

In which case, it would be more accurate to do
=IF(ISNA(X31),"Inactive Account",restofformula)

But I just found it simpler to use the IFERROR on the whole formula.