You can use

=CHOOSE(1+(C3020)+(C3040)+(C3050),40,60,80,100)

or

=VLOOKUP(C30,{0,40;21,60;41,80;51,100},2)

I try to stay away from nested IFs when I can, but it's really a matter of
preference.


"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!!!