OK I got it to work with this formula. Now I need it to be =40, =60, etc. I
keep cetting a "Value" in cell
This works
=IF(C5=20,SUM(B39*2),B39)

I thought it s/b like this but it does not work
=IF(C5=20,SUM(B39*2),B39),IF(C5=40,SUM(B39*3),B3 9),IF(C5=60,SUM(B39*4),B39)))

"MCrum" wrote:

How do I use a "IF" comaand. I have a value for instance in A1 and a value in
A2. If the value increases in A1 by more than 20 I need to add another value
from A3 to A2 and get a total in B1. If over 40 I need to add A3 again etc..

Any help would be good.