| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CELL ( )
Can someone give me an example when we need to use
=CELL("contents",A1) instead of =A1? Thanks. Epinn |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CELL ( )
Per Excel Help:
"Remark The CELL function is provided for compatibility with other spreadsheet programs." Does that help? *********** Regards, Ron XL2002, WinXP "Epinn" wrote: Can someone give me an example when we need to use =CELL("contents",A1) instead of =A1? Thanks. Epinn |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CELL ( )
Yes, I read that. If I am not mistaken, I have seen CELL ( ) with other info_type than "contents" used *not* for compatibility purpose. But I didn't see this happening with "contents." Hence, my first post. Is it fair to say that there is absolutely no use of "contents" except for compatibility with other spreadsheet? Never say "never?" <g
Thanks. Epinn "Ron Coderre" wrote in message ... Per Excel Help: "Remark The CELL function is provided for compatibility with other spreadsheet programs." Does that help? *********** Regards, Ron XL2002, WinXP "Epinn" wrote: Can someone give me an example when we need to use =CELL("contents",A1) instead of =A1? Thanks. Epinn |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CELL ( )
I can't think of a reason to use it in Excel. Perhaps in the "other"
spreadsheets, that context actually displays the contents/formula of the cell. So....there's a probablilty of zero that I would use it in Excel...but... I would NEVER say never. <vbg *********** Regards, Ron XL2002, WinXP "Epinn" wrote: Yes, I read that. If I am not mistaken, I have seen CELL ( ) with other info_type than "contents" used *not* for compatibility purpose. But I didn't see this happening with "contents." Hence, my first post. Is it fair to say that there is absolutely no use of "contents" except for compatibility with other spreadsheet? Never say "never?" <g Thanks. Epinn "Ron Coderre" wrote in message ... Per Excel Help: "Remark The CELL function is provided for compatibility with other spreadsheet programs." Does that help? *********** Regards, Ron XL2002, WinXP "Epinn" wrote: Can someone give me an example when we need to use =CELL("contents",A1) instead of =A1? Thanks. Epinn |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Linear Mode
