Excel Percentage Formula

		Microsoft Office Forums > Microsoft Excel > Excel
Excel Percentage Formula

06-07-2018, 10:54 PM

Shashi Kant Shashi Kant is offline

Windows 7 32bit Excel Percentage Formula

Office 2016

Novice

Join Date: May 2018

Posts: 16

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)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
percentage calculation formula	yoyo4	Excel	10	11-15-2017 11:44 AM
Percentage of . . .	chaserwill	Excel	1	03-10-2017 09:28 AM
What is the formula for getting the percentage for time	phoenix666!	Excel	1	07-29-2016 08:18 AM
overall percentage	ketanco	Project	1	08-04-2012 05:56 AM
percentage on columns	911	Excel	1	09-01-2010 09:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:27 PM.