If & And Statement Help

[mdhaver]

I need a formula in cell U3

If the value of s3>=5, then add the value of T3 with a cap of 5 if the value of G3>=25

but if the value of G3<25 add the value of t3 with a cap of 3 only if s3>=3

HELP!

 

[bbott]

If the value of s3>=5, then add the value of T3 with a cap of 5 if the value of G3>=25

When you say 'add the value of T3', what are you adding? S3 + T3? Or just putting T3 with a cap of 5 in U3?

 

[Eric Golf]

Hi,

"... add the value of T3 ..." to what?

=IF(G3<25,IF(S3>=3,MIN(T3+1,3),"x"),IF(S3>=5,MIN(T3+1,5),"x"))

Replace 1 with whatever you want to add T3 to and replace "x" with whatever you want if neither is true

Hope this helps,

Eric.

 

[mdhaver]

When you say 'add the value of T3', what are you adding? S3 + T3? Or just putting T3 with a cap of 5 in U3?

In cell U3
If G3<25 If S3>3 S3+T3 but cap T3 at 3
AND
If G3>=25 If S3>5 S3+T3 but cap T3 at 5

 

[AliGW]

Try:

=IF(AND(G3<25,S3>3),S3+IF(T3>3,3,T3),IF(AND(G3<25,S3>3),S3+IF(T3>3,3,T3),"")

 

[bbott]

Give this a shot:

=IF(AND(G3>=25,(S3+T3)<=5),S3+T3,IF(AND(G3<25,(S3+T3)<=3),S3+T3,""))

 

[mdhaver]

Try:

=IF(AND(G3<25,S3>3),S3+IF(T3>3,3,T3),IF(AND(G3<25,S3>3),S3+IF(T3>3,3,T3),"")

That did not work.

 

[AliGW]

That did not work.

In what way did it not work? Error message? Please be specific.

 

[mdhaver]

• An error message added one additional close parentheses. After doing so formula returns no value.</SPAN>

 

[bbott]

=IF(AND(G3>=25,(S3+T3)<=5),S3+T3,IF(AND(G3<25,(S3+T3)<=3),S3+T3,""))

Did you try my solution? It's slightly different than AliGW's.