zero error

  • Thread starter Thread starter tryn2learn
  • Start date Start date
T

tryn2learn

Good morning

I'm trying to do an IF formula to resolve the #DIV/0! error that i get in
fields that are still waiting on data.

this is my formula: =IF(SUM(C20/I20)=0,0,(C20/I20))

i appreciate your help.
 
=if(iserror(c20/d20),0,c20/d20)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"tryn2learn" escreveu:
 
That worked perfectly... thank you very much.

Ma you both have a Merry Christmas and Happy New Year!
 

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

How do I stop #DIV/0! when some of my values are zero? 3
Help on an IF formula 3
IF Function 3
Formula showing zero's 12
Identify month in a period and run a formula 4
how can i do this? 3
need formula help 2
Using 2 IF statements for the same cell 2

Back
Top