How to NOT display "FALSE" in nested if formula?

[biggmann]

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

 

[Marcelo Branco]

Maybe this formula

=IF(ISNUMBER(MATCH(E69,{1;2;3;4;5;6;7;8;9},0)),C69*(1+E69/10),"")

 

[biggmann]

Thank you for the formula, I disnt know if the isnumber and how it could be used, much easier then the way I had. I appreciate this.

 

[Marcelo Branco]

You are welcome and tks for the feedback