Thread: ISNUMBER or IFERROR
View Single Post
 
Old 10-17-2019, 10:06 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
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),"")
Reply With Quote