div

R

rob

can i put a formula to stop div/0 in the formula cells
should there be no data in the cells making up the data?

thanks for your help

rob
 
G

Gordon

rob said:
can i put a formula to stop div/0 in the formula cells
should there be no data in the cells making up the data?

thanks for your help

rob
Click to expand...

Certainly. try +IF(A1=0,"",A2/A1)
 

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

Newbie Help - IF Yes No Function 0
Extract name, address and ph# 8
How to render HTML inside a Powerpoint slide through VBA 0
Surpress Average Error 3
Supress DIV/0 2
incorporate the remove #DIV/0! code into another formula to get bl 5
macro - replace 2
Error Handling 1

Top