I need parentheses help. I keep getting the error that I have one or more extra closed parentheses.
Here is my formula:
=IF(AZ5*.8)+AO5<50, (AZ5*.8)+AO5*0.11, IF(AZ5*.8)+AO5<1000, 5.50+((AZ5*.8)+AO5-50)*0.06, 6+57+((AZ5*.8)+AO5 -1000)*0.02)
What I am trying to do is:
Give 20% off AZ.
Add AO to AZ with 20% off.
if AZ+AO is less than 50 then multiply the sum of AZ*.8 plus AO by .11
if AZ+AO is less than 1000 then multiply the sum of AZ*.8 plus AO by .06
if AZ+AO is more than than 1000 then multiply the sum of AZ*.8 plus AO by .02
Any help would be appreciated.
Here is my formula:
=IF(AZ5*.8)+AO5<50, (AZ5*.8)+AO5*0.11, IF(AZ5*.8)+AO5<1000, 5.50+((AZ5*.8)+AO5-50)*0.06, 6+57+((AZ5*.8)+AO5 -1000)*0.02)
What I am trying to do is:
Give 20% off AZ.
Add AO to AZ with 20% off.
if AZ+AO is less than 50 then multiply the sum of AZ*.8 plus AO by .11
if AZ+AO is less than 1000 then multiply the sum of AZ*.8 plus AO by .06
if AZ+AO is more than than 1000 then multiply the sum of AZ*.8 plus AO by .02
Any help would be appreciated.