Thread: [Solved] Excel Percentage Formula
View Single Post
 
Old 06-07-2018, 03:38 AM
Shashi Kant Shashi Kant is offline Windows 7 32bit Office 2016
Novice
  
Join Date: May 2018
Posts: 16
Shashi Kant is on a distinguished road
Default
Dear Friend,


Kindly find the attachment, it might be helpful for you.
Your Value in Range("A2") and the used formula is below.

=IF(A2<=8555.5,0,IF(A2<=10000,(A2-8555.5)*15%,IF(A2<=83333,216.675+(A2-10000)*20%,14883.28+(A2-83333)*30%)))
Attached Files
File Type: xlsx Book2.xlsx (8.7 KB, 9 views)
Reply With Quote