Formula error?

[jhodge]

Hi,
I'm having some problems with a formula I want to use. I hav
entries linked to another sheet that based on the number will b
divided by another number from the linked sheet. The problem is tha
the answer does not come out right.
Example:

Cell B32
=SUM('Cheese Vat Sheet'!C12:C15) (18000 example)

should be divided by

Cell D32
='Cheese Vat Sheet'!G3 (2 example)

if

Cell B32>0
=IF(B32>0,B33/D33,"")

the result is coming out as 9455 for some reason. Is there anythin
else I need for the formula?

thanks

Jim

_2

 

[DNF Karran]

Shouldn't the function be

=IF(B32>0,B32/D32,"")

not

=IF(B32>0,B33/D33,"")

Dunca

 

[Jerry W. Lewis]

It would depend greatly on what is in B33 and D33; you have only
provided B32 and D32.

Assuming that either the 32s or 33s are a misprint and refer to the same
cells, then ='Cheese Vat Sheet'!G3 probably contains approximately 1.9,
but is formatted to display no decimal places. Try formatting that cell
as General to see what is really there.

Formatting changes the display, but not the actual value (and therefore
not the result of calculations with the value). If you want to
calculate with the rounded value, you must either explicitly round, as in
=IF(B32>0,ROUND(B33,0)/ROUND(D33,0),"")
or else go to Tools|Options|Calculation and check "Precision as displayed"

Jerry