If I have a SUMIF formula in D1 and in F1 I want =45/D1 then I replace the
F1 formula by
=IF(D1=0,"X",45/D1) to avoid division by zero
The X can be replaced by anything or deleted leaving ""
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"Robbro" wrote in message
...
I have a sumifs statement that totals lbs by customer and lot and date.
Sometimes it will return a value of 0 for certain date ranges. Later on
in
the spreadsheet I divide by lbs and I dont want 0 lbs to return an error,
so
I'm trying to put an if statement in to return 0 if lbs is 0, but I cannot
find a value that will work in the following....
=if(lbs=0,0,formula), I have also tried - which is what shows up in the
lbs
column instead of 0, and I have tried "", "-", and "0". What value do i
put
in my IF statement to match a 0 sumifs???