Sep 18 2019 09:42 AM
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!
Sep 18 2019 10:16 AM
SolutionSep 18 2019 10:16 AM
SolutionThat could be
=IF(C7>128400,C7*0.9235*0.029+15921.6,C7*0.9235*0.153/2)