percentage calculation formula

		Microsoft Office Forums > Microsoft Excel > Excel
percentage calculation formula

11-15-2017, 10:03 AM

NBVC

Windows 10 percentage calculation formula

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

Quote:

Originally Posted by xor

I think there is a space too much in the last IF (0. 1). Try:

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

xor, you are also mixing commas and semi-colons as parameter separators...

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 05:57 PM.