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.
Apr 3 in Others 44 views

## 1 answer to this question.

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.

• 63,000 points

## Excel formula to get certain cell if the value is between 2 numbers

So, first with vlookup(): A formula so you ...READ MORE

## I am working as a Oracle apps DBA I am planning to change the domain . Is it good if I shift to aws?

I am also working as an Oracle ...READ MORE

## Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

## Excel delete row if column contains value from to-remove-list

Given sheet 2: ColumnA ------- apple orange You can flag the rows ...READ MORE

## IF function in combination with an Round function Excel

I'm not sure if it is a ...READ MORE

## IF formula to compare a date with current date and return result

You can enter the following formula in ...READ MORE

## Excel Formula - if values in columns all contain X then return

You can use the AND function: = IF(AND(A3="OK";B3="OK";C3="OK");"everything ...READ MORE