excel cell has =A!$AS$1:$AY$20. What is the ! and formula doing?

Posted to microsoft.public.excel.worksheet.functions

opentalon

external usenet poster

Posts: 1

excel cell has =A!$AS$1:$AY$20. What is the ! and formula doing?

I received a spreadsheet that includes a list of formaulas that I do not
understand. The person that sent it, did not create it and was unaware the
codes existed. What do these cell do and what are they referencing?
=A!$B$1:$I$6
=A!$C$25
=A!$A$1:$M$55
=A!$C$23
=A!$E$23

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
using more than 1 formula in the same cell in excel	cerobeth	Excel Worksheet Functions	7	October 1st 07 01:22 PM
Update Excel cell in formula not refreshing answer cell	Johnny	Excel Discussion (Misc queries)	2	June 21st 07 05:49 AM
ExcelExcel 2002 display formula in another cell as text	Oldersox	Excel Worksheet Functions	1	January 10th 07 06:01 AM
Excel Formula if cell is empty then no if text in cell then yes	Kathy	Excel Worksheet Functions	2	December 20th 06 05:24 PM
Need formula in Excel to substract cell D from Cell C	Louise	New Users to Excel	2	January 25th 06 05:52 PM

All times are GMT +1. The time now is 06:41 PM.

Menu

About Us