CELL ( )

  • Thread starter Thread starter Epinn
  • Start date Start date
E

Epinn

Can someone give me an example when we need to use

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

Thanks.

Epinn
 
Per Excel Help:

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

Does that help?
***********
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>

Thanks.

Epinn

Per Excel Help:

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

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

XL2002, WinXP
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
SUMIF with criteria "<>" & "=" 4
Excel Need Countifs Formula Help 0
using the Cell function 2
compare three cells 1
How do I drag a hyperlink series to fill instead of copy? 2
how to display my cursor cell content in another cell.... 6
Formula to answer YES or No 4

Back
Top