| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can anyone tell me what this formula means?
IF(C348="","",(SUM(C351)/1))
What is it checking for in C348? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Linear Mode
