ISNUMBER or IFERROR

caz46 · #1 10-17-2019, 11:16 AM

Hello,

I have the following equation: =IF(I3=1,20,IF(I3>1,(I3-1)*15+20,IF(J3>=1,(J3*100),"")))*IF([@Paid]="Unpaid",-1,1)

When I add a new row, it returns #VALUE, my question is, do I use ISNUMBER OR IFERROR in the equation, and where should I add it?

Thanks in advance for your help.
Caz

ArviLaanemets · #2 10-17-2019, 10:06 PM

In case you want an empty cell whenever any error occurs:

Code:

=IFERROR(IF(I3=1,20,IF(I3>1,(I3-1)*15+20,IF(J3>=1,(J3*100),"")))*IF([@Paid]="Unpaid",-1,1),"")

caz46 · #3 10-21-2019, 12:28 PM

That works well.

Thanks for your help.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Expanding =IF(ISNUMBER(SEARCH	sru	Excel	6	03-09-2018 07:50 AM
Using IFERROR & FIND Function	BrookeJ239	Excel	5	09-30-2017 12:02 AM
IFERROR not (consistently) working	John 1978	Excel	8	04-26-2017 12:05 AM
ISNUMBER formula not working	bishweshwar	Excel	3	03-13-2017 10:07 AM
IF, ISNUMBER & AND function	Dkline	Excel	3	06-04-2014 06:40 AM