percentage calculation formula

		Microsoft Office Forums > Microsoft Excel > Excel
percentage calculation formula

11-15-2017, 08:11 AM

xor

Windows 10 percentage calculation formula

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

In B2:

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

Tags

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:09 AM.