Thread: percentage calculation formula
View Single Post
 
Old 11-15-2017, 10:03 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
Quote:
Originally Posted by xor View Post
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...
Reply With Quote