Thread: if or formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
enyaw
 
Posts: n/a
Default if or formula

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