Help understaning an IF Statement

B

big mann

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

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

many thanks for your assistance
 
S

sumitk

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
 
O

Otto Moehrbach

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
 
Top