If statment to clear a range of cells

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 %.

With a Function, it's not possible in the way you are suggesting. If A1:G13 contain formulas, you can amend them with an IF statement to say

Please Login or Register  to view this content.

Otherwise, you can use VBA in your spreadsheet (right click on the tab and "View Code". This code runs every time you change R10 and if it's 0, then it clears A1:G13.

Please Login or Register  to view this content.

Do either of these options work for you?

ChemistB

Yes the second option is what I was looking for, I was also curious if I could do a similar command to "hide" those cells instead of deleting them, if this isn't possible I can live with it.

Thanks

You can hide rows or columns but not individual cells. You could have the code make the font color of those cells white which would effectively hide them but if they were selected, the values would appear in the formula bar.

ChemistB