|
|
#1
10-17-2019, 11:16 AM
|
|||
|
|||
ISNUMBER or IFERROR
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 
|
|
|
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 |
Windows 8 
Office 2013
Threaded Mode