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...