Thread
:
ISNUMBER or IFERROR
View Single Post
10-17-2019, 10:06 PM
ArviLaanemets
Windows 8
Office 2016
Expert
Join Date: May 2017
Posts: 873
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),"")
ArviLaanemets
View Public Profile
Find all posts by ArviLaanemets