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!!!