Can anyone tell me what this formula means?
 

IF(C348="","",(SUM(C351)/1))

What is it checking for in C348?

Thank you

Can anyone tell me what this formula means?
 

It is checking to see if C348 is blank (i.e. has no entry), if it is blank it
returns a blank, if it is not blank it returns the sum of C351 divided by 1,
which is unusual becasue you usually sum a range such as C351:C360 for
example, not a single cell.

"Shazzer" wrote:

IF(C348="","",(SUM(C351)/1))

What is it checking for in C348?

Thank you

Can anyone tell me what this formula means?
 

Thanks for that hot dogs.

"hot dogs" wrote:

It is checking to see if C348 is blank (i.e. has no entry), if it is blank it
returns a blank, if it is not blank it returns the sum of C351 divided by 1,
which is unusual becasue you usually sum a range such as C351:C360 for
example, not a single cell.

"Shazzer" wrote:

IF(C348="","",(SUM(C351)/1))

What is it checking for in C348?

Thank you

Can anyone tell me what this formula means?
 

Nothing. If the cell is empty then blank else c351/1 which makes no sense
cuz this is the same.

IF(C348="","",C351)

--
Don Guillett
SalesAid Software

"Shazzer" wrote in message
...
IF(C348="","",(SUM(C351)/1))

What is it checking for in C348?

Thank you

Can anyone tell me what this formula means?
 

Perhaps the person who originally created the formula either did not
understand Excel well or else was experimenting with IF THEN ELSE syntax???
--
Brevity is the soul of wit.


"Don Guillett" wrote:

Nothing. If the cell is empty then blank else c351/1 which makes no sense
cuz this is the same.

IF(C348="","",C351)

--
Don Guillett
SalesAid Software

"Shazzer" wrote in message
...
IF(C348="","",(SUM(C351)/1))

What is it checking for in C348?

Thank you