View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trying To Excel
 
Posts: n/a
Default What does this function do =+IF(ISERR(F27/G27),0,F27/G27)

Thanks, great answer right to the point

"JE McGimpsey" wrote:

It's overkill for eliminating a #DIV/0 error when G27 = 0. The + is just
a superfluous unary plus character that is typically inserted by Lotus
users. It's completely unnecessary in XL.

A better alternative (i.e., that wouldn't mask other errors) is

=IF(G27=0,0,F27/G27)


In article ,
Trying To Excel <Trying To wrote:

I saw this function in a file that was sent to me. The situation called for a
simple division formula. I dont understand what this formula is saying.