Excel - allow result to change if value is greater than

Question

This straightforward Excel spreadsheet I made many years ago has worked perfectly for me. I now desire a new cost for sandblasting anything longer than 1200 inches. In my screenshot, E9 multiplies C9 and D9 to get the product's size, and the result is entered in E9. If the size exceeds 1200 in C9 or D9, I need the price result in F9 to be different. When I create the D9 value 1201, I need it to use box E4's rate for pricing the product rather than E3's rate. The different rate from E4 is used when I increase the size beyond 1201, but it only inserts the £77 figure and does not multiply the outcome by the £77. This almost works, however, it doesn't multiply the E9 box by the E4 box if either C3 or D3 has exceeded the 1200 number.

Answer 1

Try this:

=IF(OR(C9>1200,D9>1200),E9*E$4,E9*E$3)

It will determine if C9 or D9 is greater than 1200. E9 will be multiplied by E4 if either (or both) of those integers is more than 1200. It will multiply E9 by E3 if neither of them is higher than 1200.

This is for cell F9, but it will still function if you slide it down to a lower row.