Excel - allow result to change if value is greater than

0 votes
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, 2023 in Others by Kithuzzz
• 38,010 points
345 views

1 answer to this question.

0 votes

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.

answered Apr 3, 2023 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

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

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

answered Feb 11, 2023 in Others by Kithuzzz
• 38,010 points
868 views
0 votes
1 answer
0 votes
1 answer

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

answered Sep 23, 2022 in Others by narikkadan
• 63,720 points
3,334 views
0 votes
1 answer

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

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

answered Nov 6, 2022 in Others by narikkadan
• 63,720 points
1,346 views
0 votes
1 answer

IF function in combination with an Round function Excel

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

answered Sep 25, 2022 in Others by narikkadan
• 63,720 points
2,879 views
0 votes
1 answer

Excel If field with rounding

Here's your formula. Assumes your cell containing ...READ MORE

answered Sep 27, 2022 in Others by narikkadan
• 63,720 points
650 views
0 votes
1 answer

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

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

answered Sep 27, 2022 in Others by narikkadan
• 63,720 points
722 views
0 votes
1 answer

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

answered Nov 4, 2022 in Others by narikkadan
• 63,720 points
1,308 views
0 votes
1 answer

(Excel) If cell is greater than <condition> then minus <number>

The IF function to calculate B5 (amount ...READ MORE

answered Nov 7, 2022 in Others by narikkadan
• 63,720 points
1,045 views
0 votes
1 answer

Excel - How do I round a date type to the next hour if it is more than one minute

Add almost 30 minutes and it'll get ...READ MORE

answered Mar 27, 2023 in Others by narikkadan
• 63,720 points
267 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP