Replacing Values

G

George Schneider

I have a query that performs a calculation. The two fileds are QOH and Weekly Sales. I divide those two values to get a value for this new field. I get a #error when I divide when both values are 0 because you can't divid 0 into 0. Is there a way to replace all the #error values with 0. is so how would I accomplish this.
 
J

John Vinson

I have a query that performs a calculation. The two fileds are QOH and Weekly Sales. I divide those two values to get a value for this new field. I get a #error when I divide when both values are 0 because you can't divid 0 into 0. Is there a way to replace all the #error values with 0. is so how would I accomplish this.
Click to expand...

Try:

IIF([Weekly Sales] = 0, 0, [QOH] / [Weekly Sales])
 

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

VBA multiple list of values for variable 1
Word macro that can call cells out of Excel for a find and replace 0
Use TODAY() function as the criteria in a SUMIF formula 1
Drop down list control value in vba 2
Calculate the median value before a specified list 0
Combining three files when middle file has sections with endnotes 2
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0

Top