if or formula

[Guest]

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 "-".

 

[Guest]

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:

 

[macropod]

Hi enyaw,

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

 

[Guest]

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.

Hi enyaw,

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

--
macropod
[MVP - Microsoft Word]

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 "-".

 

[Guest]

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.

Hi enyaw,

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

--
macropod
[MVP - Microsoft Word]

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 "-".