CELL ( )

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Epinn - 28 Oct 2006 21:35 GMT

Can someone give me an example when we need to use

=CELL("contents",A1) instead of =A1?

Thanks.

Epinn

Reply to this Message

Ron Coderre - 28 Oct 2006 22:27 GMT

Per Excel Help:

"Remark
The CELL function is provided for compatibility with other spreadsheet
programs."

Does that help?
***********
Regards,
Ron

XL2002, WinXP

> Can someone give me an example when we need to use
>
[quoted text clipped - 3 lines]
>
> Epinn

Reply to this Message

Epinn - 28 Oct 2006 23:56 GMT

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

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
>
[quoted text clipped - 3 lines]
>
> Epinn

Reply to this Message

Ron Coderre - 29 Oct 2006 00:18 GMT

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

> 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>
>
[quoted text clipped - 24 lines]
> >
> > Epinn

Reply to this Message