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
|