I created a table that covers a range of cells (A1:G13), and I would like to make an If statement like if R10=0, (a1:g13) " ", x

So i need a large range of cells blank I guess I could do each cell individually but I'd rather not if theres another way.

I also have a simple function that is " =f10(which happens to be a %) & " X" and I can't seem to get excel to change the decimal into a % even thou the original is a %.