IF(C30<=20,40,IF(AND(C3021,C30<40),60,IF(AND(C30 41,C30<50),80,IF(C31=51,100)))

Note that the way you have your logic set up, this statement doesn't
consider valyes of 21, 40, 41, or 50. If you want those values to be
considered, then the formula should be re-written with =21, <=40, etc.

Dave
--
Brevity is the soul of wit.


"Chris B." wrote:

I have a commission statement that I need to set functions in.

I need to say if cell C30 is less than or equal to 20, then C31=$40, if C30
is between 21-40, then C31 is $60, if C30 is between 41-50, then C31 is $80,
and if C30 is greater than or equal to 51 then C31 is $100.

Please Help!!!