I need help getting this formula to work. Can anyone help?
=OR(IF(((I16/F16)*J16=0),"-",((I16/F16)*J16)),IF(ISERROR((I16/F16)*J16),"-",((I16/F16)*J16)))
If the formula outputs a zero or an error value I need the value of the cell
to be outputted as "-".

I think you mean this:
=IF(OR(ISERROR((I16/F16)*J16),(I16/F16)*J16=0),"-",(I16/F16)*J16)
But watch out! It still doesn't treat zero dividor (if F16=0)!

Regards,
Stefi


€ženyaw€� ezt Ã*rta:

I need help getting this formula to work. Can anyone help?
=OR(IF(((I16/F16)*J16=0),"-",((I16/F16)*J16)),IF(ISERROR((I16/F16)*J16),"-",((I16/F16)*J16)))
If the formula outputs a zero or an error value I need the value of the cell
to be outputted as "-".

Hi enyaw,

Try:
=IF(OR(ISERROR(I16*J16/F16),I16*J16/F16=0),"-",I16*J16/F16)

--
macropod
[MVP - Microsoft Word]


"enyaw" wrote in message
...
I need help getting this formula to work. Can anyone help?

=OR(IF(((I16/F16)*J16=0),"-",((I16/F16)*J16)),IF(ISERROR((I16/F16)*J16),"-",
((I16/F16)*J16)))
If the formula outputs a zero or an error value I need the value of the
cell
to be outputted as "-".

This formula does not let me insert a "-" in the cell if the formula =0. I
need the cells to be empty if the formula = 0 because i need to do an average
of the cells after it.

"macropod" wrote:

Hi enyaw,

Try:
=IF(OR(ISERROR(I16*J16/F16),I16*J16/F16=0),"-",I16*J16/F16)

--
macropod
[MVP - Microsoft Word]


"enyaw" wrote in message
...
I need help getting this formula to work. Can anyone help?

=OR(IF(((I16/F16)*J16=0),"-",((I16/F16)*J16)),IF(ISERROR((I16/F16)*J16),"-",
((I16/F16)*J16)))
If the formula outputs a zero or an error value I need the value of the
cell
to be outputted as "-".

Maybe this is what you want:
=IF(ISERR((I16/F16)*J16),"",(I16/F16)*J16)
Regards,
Stefi


€ženyaw€� ezt Ã*rta:

This formula does not let me insert a "-" in the cell if the formula =0. I
need the cells to be empty if the formula = 0 because i need to do an average
of the cells after it.

"macropod" wrote:

Hi enyaw,

Try:
=IF(OR(ISERROR(I16*J16/F16),I16*J16/F16=0),"-",I16*J16/F16)

--
macropod
[MVP - Microsoft Word]


"enyaw" wrote in message
...
I need help getting this formula to work. Can anyone help?

=OR(IF(((I16/F16)*J16=0),"-",((I16/F16)*J16)),IF(ISERROR((I16/F16)*J16),"-",
((I16/F16)*J16)))
If the formula outputs a zero or an error value I need the value of the
cell
to be outputted as "-".