I am working on a sheet that has a nested if formula in it, the formula checks the cell beside it for a number and does a calculation based on that number. The problem I am having is when the cell is empty and there is no calculation then it displays "FALSE". Now this is ok for me but the office I am doing it for may get confused so I want to erase the false displayed but I am unable to make that happen. Can someone point me in the right direction on what I need to do here?
Here is my formula:
=IF(E69 = 1,C69*1.1,IF(E69 = 2,C69*1.2,IF(E69 = 3,C69*1.3,IF(E69 = 4,C69*1.4,IF(E69 = 5,C69*1.5,IF(E69 = 6,C69*1.6,IF(E69 = 7,C69*1.7,IF(E69 = 8,C69*1.8,IF(E69 = 9,C69*1.9)))))))))
Thanks
Here is my formula:
=IF(E69 = 1,C69*1.1,IF(E69 = 2,C69*1.2,IF(E69 = 3,C69*1.3,IF(E69 = 4,C69*1.4,IF(E69 = 5,C69*1.5,IF(E69 = 6,C69*1.6,IF(E69 = 7,C69*1.7,IF(E69 = 8,C69*1.8,IF(E69 = 9,C69*1.9)))))))))
Thanks