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

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

many thanks for your assistance


--
big mann
------------------------------------------------------------------------
big mann's Profile: http://www.excelforum.com/member.php...o&userid=34543
View this thread: http://www.excelforum.com/showthread...hreadid=543085

If 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

"big mann" wrote:


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

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

many thanks for your assistance


--
big mann
------------------------------------------------------------------------
big mann's Profile: http://www.excelforum.com/member.php...o&userid=34543
View this thread: http://www.excelforum.com/showthread...hreadid=543085

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
"big mann" wrote in
message ...

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

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

many thanks for your assistance


--
big mann
------------------------------------------------------------------------
big mann's Profile:
http://www.excelforum.com/member.php...o&userid=34543
View this thread: http://www.excelforum.com/showthread...hreadid=543085