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!

 

[mdhaver]

Yes, it adds S3 and T3 even if the condition of having at least a value of more than 5 is not met.

 

[bbott]

OK, so the value in U3 can be more than 5, but not the value in T3, correct? I thought the sum was to be capped at 5, not just the value in T3 (same logic applies for capping at 3).

 

[bbott]

Does this give you the result you're looking for?

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

 

[mdhaver]

No. The condition of at least 5 from S3 is not met (the value is currently 1). The value in t3 is currently 4. U3 in this situation should be 1 and this above formula provides a value back of 5.

 

[bbott]

OK, one more try. This assumes that you want U3 = S3 if none of the conditions are met (as in your example above):

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

 

[mdhaver]

That worked! Thank you so much!!!

 

[bbott]

You're welcome. Glad I could finally find you a solution!