math operations
Posted by Brian Pickell on February 05, 2002 6:08 PM
I'm trying to take the value of a cell which is a percentage and check to make sure that percentage is between a certain percentage and if it is multiply another cell by another percentage.. for example say cell D28 has 6.1% and cell D30 has $2200.00 the formula I am using that is not working is as follows
=IF(D28>0.06 & D28<.07,ROUND(D30*.19.2),"")
for some reason if D28 is above 6% it always comes back as true even if its 10%
that will not work for what I'm trying to accomplish.
Any help would be great.
Posted by Russell Hauf on February 05, 2002 7:52 PM
Let's see, try this:
=IF(D28>0.06,IF(D28<0.07,ROUND(D30*0.19,2),""))
Hope this helps,
Russell
Posted by Yogi Anand on February 05, 2002 8:12 PM
Hi Russell:
I am sorry I did not see your response to Brian Pickell's post -- anyway, now he has two similar but slightly different formulations that work.
Cheers!
