Yeah, you can do that:

=IF(B1<5,C1,IF(AND(b54,B5<11),D1,E1)

Dave
--
Brevity is the soul of wit.


"RS" wrote:

Will Excel allow you to do an if/then statement which evaluates a value and
applies a different equation depending on what that value is?

i.e. If B1<5, then use this equation: =(5/100*A1-(A1*B1/100))/(5/100)

or simpler ... If B1<5, then C1

or If B1=the numbers 5-10, then D1(formula)

If B110, then E1(formula)

Any help would be much appreciated!! Thanks!!!