View Single Post
  #5   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

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