#DIV/O!

J

jerie

I have a formula as follows =TRUNC(G6/F6+0.5) when there
is no value in the cell it returns #DIV/O!
Is there a way that the cell becomes blank instead of
#DIV/O!

thank you all
rgs jerie
 
J

joeu2004

jerie said:
I have a formula as follows =TRUNC(G6/F6+0.5) when there
is no value in the cell it returns #DIV/O!
Is there a way that the cell becomes blank instead of
#DIV/O!
Click to expand...

=if(f6 = 0, "", trunc(g6/f6+0.5))
 

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

Similar Threads

#DIV/0! 1
#DIV/O! Errror with Absolute Number Calculation 7
how to average a range of cells and ignore #div/0! answer 4
I want to see blank cell rather to see #DIV/0! 4
Div / 0 5
How to avoid #DIV/0, I AM USING =AVERAGE(IF(F30:F69=3,O30:O69,"0") 5
When dividing by 0 can i show a result of 0 instead of #DIV/0 7
blank instead of DIV/0! 2

Top