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
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
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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks