pflynn

For "between 91 and 99"

=IF(AND(A1091%,A10<99%),A10*1.25,0)

For 91 to 99

=IF(AND(A10=91%,A10<=99%),A10*1.25,0)

Gord Dibben Excel MVP

On Tue, 21 Dec 2004 17:01:02 -0800, pflynn
wrote:

I am trying to write a formula in which it can figure the following if a cell
is between 91% and 99% then it should multiply by 1.25 if it is not then it
should equal 0