Multi IF formula with rounding help?

Utradeshow

Well-known Member
Joined
Apr 26, 2004
Messages
807
Office Version
  1. 365
Hi ALL,

I have a calculation I need to come up with that is way to complex for me. Here is what I'm trying to do.

I have Cell A1 that I will be Multiplying by cell B1, However if either value in A1 or B1 value is =>60=Value, If over 60 then value is 96. If =>120, Value if over 120 then value 144.

Is that even possible??
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Hi,
What you're describing has a circular logic. Can you post an example of the expected result?
 
Upvote 0
See if this is what you're looking for.
Excel Formula:
=LET(m,MAX(A2:B2),IF(m<60,A2*B2,IF(m<120,96,144)))
 
Upvote 0
STORAGE CALCULATOR - TEST.xlsx
ABCDEFG
1LengthWidthRESULTNEEDED RESULT
2484025250-60VALUE
36140325061-12096
440753950121-192144
5108405656
6121406375
7130406868
Sheet2
Cell Formulas
RangeFormula
C2:C7C2=ROUND(A2*B2/76.5,0)
 
Upvote 0
The above isn't what you're looking for, but this is closer. Can you explain the differences in red?
Book1
ABCDEFGH
1LengthWidthNEEDED RESULTCubistCheck
248402525TRUE0-60VALUE
361405050TRUE61-12096
440755050TRUE121-192144
5108405650FALSE
6121407575TRUE
7130406875FALSE
Sheet10
Cell Formulas
RangeFormula
D2:D7D2=ROUND(PRODUCT(IF(A2:B2<60,A2:B2,IF(A2:B2<120,96,144)))/76.5,0)
E2:E7E2=D2=C2
 
Upvote 0
Solution
YES!!! I was trying to come up with a better explanation! This is Exactly what I need, The RED was my error
 
Upvote 0

Forum statistics

Threads
1,224,828
Messages
6,181,206
Members
453,022
Latest member
RobertV1609

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top