Thread: percentage calculation formula
View Single Post
 
Old 11-15-2017, 08:11 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
In B2:

=A1*(IF(A1>=20000,0.2,IF(A1>=10000,0.15,IF(A1>0,0. 1;"") )))
Reply With Quote