Posted by Brian Pickell on February 05, 2002 6:09 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<0.07,ROUND(D30*0.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.