IF,s SMALLl and LARGE and number arangment

[Adventure_Harry]

Good Day

Should be an easy one but need some help

Windows 7, Excel 2010

I have three columns A,B,C where the user enters measurements . These measurements need to be copied to D,E,F but when the smallest number is 30 or less the dimensions need to be arranged from the biggest Col D to smallest Col F. If the smallest number is bigger than 30 all measurements should be copied as is A=D B=E C=F

I am sure I can figure it out but have some time constraints. Let see who is the faster me or the board

Harry

 

[CROY1985]

In D2: =IF(OR($A2<30,$B2<30,$C2<30),MAX($A2:$C2),A2)
In E2: =IF(OR($A2<30,$B2<30,$C2<30),SUM(A2:C2)-D2-F2,B2)
In F2: =IF(OR($A2<30,$B2<30,$C2<30),MIN($A2:$C2),C2)

 

[Adventure_Harry]

Thank you SIr

I bow to your Knowledge

The only Thing I changed,due to a circular refrence warning when I copied, was
In E2: =IF(OR(A2<30,B2<30,C2<30),LARGE(A2:C2,2),B2)

Thank you once again

 

[CROY1985]

haha, thats what i wanted to use, but couldn't remember the Large bit!