Multi IF formula with rounding help?

[Utradeshow]

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??

 

[Cubist]

Hi,
What you're describing has a circular logic. Can you post an example of the expected result?

 

[Cubist]

See if this is what you're looking for.

=LET(m,MAX(A2:B2),IF(m<60,A2*B2,IF(m<120,96,144)))

 

[Utradeshow]

STORAGE CALCULATOR - TEST.xlsx
	A	B	C	D	E	F	G
1	Length	Width	RESULT	NEEDED RESULT
2	48	40	25	25		0-60	VALUE
3	61	40	32	50		61-120	96
4	40	75	39	50		121-192	144
5	108	40	56	56
6	121	40	63	75
7	130	40	68	68
Sheet2

Cell Formulas
Range	Formula
C2:C7	C2	=ROUND(A2*B2/76.5,0)

 

[Cubist]

The above isn't what you're looking for, but this is closer. Can you explain the differences in red?

Book1
	A	B	C	D	E	F	G	H
1	Length	Width	NEEDED RESULT	Cubist	Check
2	48	40	25	25	TRUE		0-60	VALUE
3	61	40	50	50	TRUE		61-120	96
4	40	75	50	50	TRUE		121-192	144
5	108	40	56	50	FALSE
6	121	40	75	75	TRUE
7	130	40	68	75	FALSE
Sheet10

Cell Formulas
Range	Formula
D2:D7	D2	=ROUND(PRODUCT(IF(A2:B2<60,A2:B2,IF(A2:B2<120,96,144)))/76.5,0)
E2:E7	E2	=D2=C2

 

[Utradeshow]

YES!!! I was trying to come up with a better explanation! This is Exactly what I need, The RED was my error