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.