What IF - formula question

G

Gene

I have an IF formula question. My cell has a formula in it =sum(H43/G43).
I want this cell blank Ҡif the result is not a percentage (the cell has
been formatted to be a %). When I drag the formula to many other cells some
of them are #DIV/O! and I want those cells to be blank.

I can’t figure out how to do this. Thanks for your time and help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top