Dividing by 0

S

SharonInGa

How do I replace the #Div/0 with a blank for records that do not have values
yet for the high field?


Low / High

364.8/ 10327 = 0.035324877
364.8 / 0 = #DIV/0!
 
J

John Spencer (MVP)

In the underlying query or in a calculation in the control's source? Basically,
you could use the expression

IIF(High = 0,Null,Low/High)
 

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 set focus (and select text) on a text box on a modeless userform? 0
Extract name, address and ph# 8
VBA multiple list of values for variable 1
Newbie Help - IF Yes No Function 0
How do I make #DIV/0! error message go away? 2
iserror problem 10
PivotTable - Filter Row 0
Ignoring Blank cells 9

Top