Hi,

The + sign is a throwback to LOTUS 123 and does nothing but is tolerated by
Excel.

=IF(P14=0,"",AVERAGE(D14:O14))

Breaking the formula down it looks at P4

Do this if P4 <0 do this
=If(P4=0,do nothing,average the cells d14:14

Mike

"RJJ" wrote:

I was givin a spreadsheet for the purpose of extracting some data. Within
this workbook are a few formulas that I only want to understand.
Specifically, what is the =+IF part of the formula mean? How would you
explain the rest of this formula?

Richard