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