First, you'll get better responses if you respond to the original thread rather
than creating a new one. That way, people will know what has been suggested, and
won't repeat it.

Here's my proposed solution:

==(AD5+AE5)*AF5*3.40-if(ad5+ae5<4,.21,if(and(ad5+ae54,ad5+ae5<8),.8,if (and(ad5+ae512,ad5+ae5<20),1.3,0)))

Some problems with the above which you will need to determine:
What happens if ad5+ae5 = 4? is between 8 and 12? or is over 20?
Putting "etc." in your query makes it very difficult to get a definitive answer.
Only you know what "etc." means, so you're better off to define it now rather
than later.
--
Regards,
Fred


"Robertgn" wrote in
message ...

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

All I'm attempting to do is tell a cell to provide one answer if so and
so and another answer is so and so. In other words here is my original
formula:
=(AD5+AE5)*AF5*3.40-.21. This is where the "if" comes into play ( I
think). If AD5+AE5 is less than (4) I want to subtract the (.21) for
the end results; if AD5+AE5 is more than (4) and less than (8) I want
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 (I
guess), but neither of the formulas worked. Perhaps someone can still
help.

Thanks,
Robertgn


--
Robertgn
------------------------------------------------------------------------
Robertgn's Profile:
http://www.excelforum.com/member.php...o&userid=29518
View this thread: http://www.excelforum.com/showthread...hreadid=492356