iferror or if(iserror)

[mrinal saha]

Hi folks,

Can we put iferror or if(iserror) to the below function to avoid any sought of error msg

IF(C146="","",IF(C146+C147=0,"",(C146-C147)/C146))

thanks
Mrinal

 

[njimack]

Does the error only occur when C146=0? If so, try this:
=IF(OR(C146="",C146+C147=0,C146=0),"",(C146-C147/C146))

 

[Sektor]

IFERROR(IF(C146="","",IF(C146+C147=0,"",(C146-C147)/C146)),"Error")