Formula Help

P

picktr

Help

=IF(E14=1,1/$E$45,"")

this formula will return a value of 1 or divisible.
but i need it to also return a value of 0.

currently it leaves the cell BLANK

To
 
P

picktr

=IF(E14=1,1/$E$45,"")

This formula returns either a 1, or
the number of cells in the range that
have the same number divisible by one.

ex each of 3 cells have 40

result is 0.333 in the corresponding cells

the rest of the column returns no value.

I need a value of 0 in the rest
 
F

Frank Kabel

Hi
did you try the solutions/ideas. If yes what wa wrong with
them?
To be honest: From your description for me your expected
result is not that clear. you may provide some example
data 8plain text - no attachment please) and describe your
expected result based on this example
 
Top