Formula between to numbers is true multiply
 

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

Have a look in HELP index for AND and then IF

--
Don Guillett
SalesAid Software

"pflynn" wrote in message
...
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

Test A1 to multiply B1 by 1.25:

=AND(A1=91%,A1<=99%)*(1.25)*B1
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"pflynn" wrote in message
...
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

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

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


=A1*1.25*AND(A10.91,A1<0.99)

or, if you are testing A1 to see whether to multiply some other cell (B1) by
1.25:

=B1*1.25*AND(A10.91,A1<0.99)


--ron