Thread: percentage calculation formula
View Single Post
 
Old 11-15-2017, 08:34 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
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
Another one:

=$A1*(0.1 + ($A1>10000)*0,05 + ($A1>20000)*0,05)

Advantges:
arithmetical operators are faster;
no limit for number of nested IF() functions
Reply With Quote