How to add contents of another cell to formula

[Harold R.]

I have the following formula =(MAX(0,SUMIF(K29,">40")-40))*1.5 I need to add cell X20 to K29. I have tried
=(MAX(0,SUMIF(K29,X20),">40"))-40))*1.5
=(MAX(0,SUMIF(K29+X20),">40"))-40))*1.5
=(MAX(0,SUMIF(K29,X20)">40"))-40))*1.5
=(MAX(0,SUMIF(K29+X20)">40"))-40))*1.5
But it doesn't work. What am I doing wrong?

 

[mikerickson]

SUMIF(K29,">40")-40

=IF(K29>40,K29,0)-40

=either -40 or K29-40

So, MAX(0,SUMIF(K29,">40")-40)

=MAX(0,K29-40)

Does =MAX(0,K29+X20-40) give you the result you want?

 

[facethegod]

Does this give you your expected result..?

=MAX((K20+X29)-40,0)*1.5

 

[Harold R.]

SUMIF(K29,">40")-40

=IF(K29>40,K29,0)-40

=either -40 or K29-40

So, MAX(0,SUMIF(K29,">40")-40)

=MAX(0,K29-40)

Does =MAX(0,K29+X20-40) give you the result you want?

Yes it does if I add *1.5 Thanks that is much simpler.