Microsoft Office Forums - View Single Post - [Solved] Excel Percentage Formula

Thread: [Solved] Excel Percentage Formula

View Single Post

Old

06-07-2018, 10:54 PM

Shashi Kant Shashi Kant is offline

Shashi Kant is offline

Shashi Kant uses Windows 7 32bit

Windows 7 32bit Shashi Kant uses Office 2016

Shashi Kant uses Office 2016

Office 2016

Novice

Join Date: May 2018

Posts: 16

Shashi Kant is on a distinguished road

Default

Dear Kideal,

Kindly use below formula...

=IF(A2<=10000,A2*15%,IF(A2<=83333,1500+(A2-10000)*20%,16166.6+(A2-83333)*30%))

Attached Files

Book2.xlsx (8.6 KB, 10 views)

Reply With Quote