Dell / Dell dm061...

I am a first time poster but i am having a lot of trouble with this. =IF(AND(D3<=48,E3<=96(D3))IF(AND(D3>=48,E3>48(E3)))IF(AND(D3>48,E3>96(48)))IF(AND(D3<=96,E3<48(96))))

Not sure if it is the parenthesis or what but I am trying to calculate the following...

Where A=Width and B=Length/orHeightIF A <=48 And B<=96 =A, IF A>=48 And B<48=B, IFA>48 And B>96=48, IF A>96 And B<48 =96.

I am kind of new to IF/AND Equations, but usually i can figure out excel on my own, this time i am really stuck. I appreciate any guidance that can be given.

Thank you in advance

Justin

This is probably closer to what your looking for: =IF(AND(D3<=48,E3<=96),D3,IF(AND(D3>=48,E3>48),E3,IF(AND(D3>48,E3>96),48,IF(AND(D3<=96,E3<48),96,""))))

MIKE

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History