Formulas > =CELL()
How to Use CELL() in Google Sheets
Description
How To Actually Use CELL() in Sheets
CELL(info_type, reference)
Try CELL yourself
In cell D1, use the CELL formula to get the address of the cell A1. The formula should return the address as a text string.
Hints (2)
-
Remember to specify the info_type as 'address'.
-
Make sure to reference the correct cell in your formula.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the CELL() formula:
Generate a CELL() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses CELL(). 2 free AI generations, no signup. Members get unlimited use.
Generate a CELL() formula