Please Help With This Nested function

Dell / Dell dm061...
November 9, 2010 at 12:40:31
Specs: Windows XP, 2.992 GHz / 1021 MB
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/orHeight

IF 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


See More: Please Help With This Nested function

Report •

#1
November 9, 2010 at 12:59:26
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

http://www.skeptic.com/


Report •
Related Solutions


Ask Question