I am trying to calculate an If Formula with multiple options and I have the 1st part, but no clue how to move forward. My initial formula is:
=IF(C7<=128400,(C7*.9235)*.153/2)
How do I add the formula for when the amount in C7 is greater than 128,400?
If greater than 128,400, I need the following calculation (C7*.9235)*.029+15921.60
I tried adding the entire string together, but keep getting an error message when I did this:
=IF(C7<=128,400,(C7*0.9235)*0.153/2),IF(C7>128400,(C7*0.9235)*0.029+15921.6)
Please HELP!
