Still trying to figure it out

[Robertgn]

I am desperately trying to learn how to use Excel and am very new and a
not a math whiz to boot. I'm probably trying to run before I can walk i
trying to use the "if" function.

All I'm attempting to do is tell a cell to provide one answer if so an
so and another answer is so and so. In other words here is my origina
formula:
=(AD5+AE5)*AF5*3.40-.21. This is where the "if" comes into play (
think). If AD5+AE5 is less than (4) I want to subtract the (.21) fo
the end results; if AD5+AE5 is more than (4) and less than (8) I wan
to subtract (.8) from the end results.
If AD5+AE5 is more than (12) and less than (20) I want subtract (1.3
from the end results etc.

I started this thread earlier today and both response were good (
guess) but both came up with an answer of .21 no matter what value
use for AD5 and AE5. I admit I had an error in my first thread abou
(12) and (20) but I have tried to correct it here. Perhaps someone ca
still help.

Thanks,
Robertg

 

[Robertgn]

Thanks so much WJ; this opens up a whole new world for me. I have it
going on now.

rgn