Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does this function do =+IF(ISERR(F27/G27),0,F27/G27)
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does this function do =+IF(ISERR(F27/G27),0,F27/G27)
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does this function do =+IF(ISERR(F27/G27),0,F27/G27)
First of all, the plus sign is unnecessary.
Former users of Lotus tend to habitually use it, since it defined a formula in Lotus, similar to the equal sign in XL. What the formula is saying is: If the division of F27 by G27 returns an error (say G27 was zero), then return zero, NOT the error. If NO error is returned, then display the results of the division. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Trying To Excel" <Trying To wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does this function do =+IF(ISERR(F27/G27),0,F27/G27)
Hi!
=+IF(ISERR(F27/G27),0,F27/G27) If F27 divided by G27 causes an error, return zero, otherwise, return the result of F27 divided by G27. An error will be generated if G27 is blank or a zero, or if either cell contains text. You don't need the "+" sign. It's superflous. =IF(ISERR(F27/G27),0,F27/G27) Biff "Trying To Excel" <Trying To wrote in message ... 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does this function do =+IF(ISERR(F27/G27),0,F27/G27)
Solved my problem, Thanks
"Ragdyer" wrote: First of all, the plus sign is unnecessary. Former users of Lotus tend to habitually use it, since it defined a formula in Lotus, similar to the equal sign in XL. What the formula is saying is: If the division of F27 by G27 returns an error (say G27 was zero), then return zero, NOT the error. If NO error is returned, then display the results of the division. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Trying To Excel" <Trying To wrote in message ... 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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does this function do =+IF(ISERR(F27/G27),0,F27/G27)
Thanks for clearing things up
"Biff" wrote: Hi! =+IF(ISERR(F27/G27),0,F27/G27) If F27 divided by G27 causes an error, return zero, otherwise, return the result of F27 divided by G27. An error will be generated if G27 is blank or a zero, or if either cell contains text. You don't need the "+" sign. It's superflous. =IF(ISERR(F27/G27),0,F27/G27) Biff "Trying To Excel" <Trying To wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |