=IF((AND(H19>=0.01,H19<=0.03)),".09")
=IF((AND(H19>=3.01,H19<=0.06)),".08")
=IF((AND(H19>=6.01,H19<=0.09)),".07")
what i was trying to accomplish is if the number in a cell falls between .01 and 3 % make the cell multiply by 9%
if cell is between 3.01 percent and 6% multiply by 8%
i believe between these % is my problem
and so on can anyone please help
thank you very much!
=IF((AND(H19>=3.01,H19<=0.06)),".08")
=IF((AND(H19>=6.01,H19<=0.09)),".07")
what i was trying to accomplish is if the number in a cell falls between .01 and 3 % make the cell multiply by 9%
if cell is between 3.01 percent and 6% multiply by 8%
i believe between these % is my problem
and so on can anyone please help
thank you very much!