Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I change a blank formula to a 0 1

Status
Not open for further replies.
roaml

roaml

Technical User
Feb 19, 2002
264
0
0
US
Hi,

I have tried to set this format to 0 but have had no luck. I am dividing two columns and is receiving "#DIV/0!" if the formula has noting to devide by.

How can I clear or format to a "0"?

Thank you.
 
Sort by date Sort by votes


Hi,

You have not included your formula and, unfortunately, I have no crystal ball.
[tt]
=if(B1=0,0,A1/B1)
[/tt]


Skip,
[sub]
[glasses] [red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen![tongue][/sub]
 
Upvote 0 Downvote
He, he. Sorry. Here it is. It is a division formula,

=D4/C4
 
Upvote 0 Downvote
Crystal ball or not, you are still the MAN. Your sample worked.

Thank you.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
504
Andrzejek
Andrzejek
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
153
SkipVought
S
TomSalvato
  • Locked
  • Question
EXCEL-formula help 2
Replies
6
Views
102
TomSalvato
TomSalvato
N1GHTEYES
  • Question
Count areas within a range 1
Replies
14
Views
551
SkipVought
S
Metzke
  • Locked
  • Question
How to Transfer Licence to New PC
Replies
11
Views
241
teknance
teknance

Part and Inventory Search

Sponsor

Back
Top