Worked Great. Thanks So Much

"Ragdyer" wrote:

Try this:

=IF(C5=60,B39*4,IF(C5=40,B39*3,IF(C5=20,B39*2,B 39)))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"MCrum" wrote in message
...
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),B3
9)))

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