View Single Post
  #3   Report Post  
RagDyer
 
Posts: n/a
Default

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