software

Can someone please help me to understand what the following piece of
code is doing , thanks

=IF('Input'!O$60=quot;quot;,quot;quot;,SUM('Input - '!D60:O60)/SUM(abc!C$13:N$13))

many thanks for your assistance--
big mann
------------------------------------------------------------------------
big mann's Profile: www.excelforum.com/member.php...oamp;userid=34543
View this thread: www.excelforum.com/showthread...hreadid=543085If cell o60 is blank, the result will be blank.

Else...
The result will be the sum of cells D60 to O60 (from the Input sheet)
divided by the sum of cells C13 to N13 (from the abc sheet)

Hope this helps.

sk

quot;big mannquot; wrote:

gt;
gt; Can someone please help me to understand what the following piece of
gt; code is doing , thanks
gt;
gt; =IF('Input'!O$60=quot;quot;,quot;quot;,SUM('Input - '!D60:O60)/SUM(abc!C$13:N$13))
gt;
gt; many thanks for your assistance
gt;
gt;
gt; --
gt; big mann
gt; ------------------------------------------------------------------------
gt; big mann's Profile: www.excelforum.com/member.php...oamp;userid=34543
gt; View this thread: www.excelforum.com/showthread...hreadid=543085
gt;
gt;

If O60 of the Input sheet is blank, result is a blank cell. Otherwise, get
the sum of D60:O60 in the Input sheet, and divide it by the sum of C13:N13
in the abc sheet. Also, that is not code (not a part of a macro). Rather
it is a cell formula. HTH Otto
quot;big mannquot; gt; wrote in
message ...
gt;
gt; Can someone please help me to understand what the following piece of
gt; code is doing , thanks
gt;
gt; =IF('Input'!O$60=quot;quot;,quot;quot;,SUM('Input - '!D60:O60)/SUM(abc!C$13:N$13))
gt;
gt; many thanks for your assistance
gt;
gt;
gt; --
gt; big mann
gt; ------------------------------------------------------------------------
gt; big mann's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34543
gt; View this thread: www.excelforum.com/showthread...hreadid=543085
gt;