percentage calculation formula

xor · #1 11-15-2017, 08:11 AM

In B2:

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

ArviLaanemets · #2 11-15-2017, 08:34 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What is the formula for getting the percentage for time	phoenix666!	Excel	1	07-29-2016 08:18 AM
Calculation of Percentage Completion of Summary Tasks	raminraiszadeh	Project	2	04-06-2015 06:38 AM
Formula Calculation	medavidcook	Excel	2	03-21-2015 03:47 AM
Formula calculation	danbl	Excel	8	02-23-2012 04:35 AM
Excel 2010 formula rounds - arithmetic average calculation	YooNaa Kim	Excel	1	06-07-2011 08:50 PM