Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What Does This Function Do?
I have a spreadsheet with the following function:-
BB!G1 What does it do please? Thanks. |
#2
|
|||
|
|||
It gets the value of cell G1 in worksheet BB.
-- HTH Bob Phillips "Saxman" wrote in message ... I have a spreadsheet with the following function:- BB!G1 What does it do please? Thanks. |
#3
|
|||
|
|||
Hi
Maybe =BB!G1 When yes, then it isn't a function, it is a cell reference - a value from cell G1 on sheet BB is returned. -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "Saxman" wrote in message ... I have a spreadsheet with the following function:- BB!G1 What does it do please? Thanks. |
#4
|
|||
|
|||
"Saxman" wrote in message
I have a spreadsheet with the following function:- BB!G1 What does it do please? Thanks. It refers to Cell G1 on Sheet BB |
#5
|
|||
|
|||
Gordon wrote:
It refers to Cell G1 on Sheet BB That's what I thought, but there isn't a sheet BB. At least that has partly answered my problem. Thanks. |
#6
|
|||
|
|||
"Saxman" wrote in message
Gordon wrote: It refers to Cell G1 on Sheet BB That's what I thought, but there isn't a sheet BB. At least that has partly answered my problem. Thanks. Are you sure there isn't a hidden sheet? If there was no sheet, that cell would return a value of #REF |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |