Last question!

[Deadloss]

Hi, can anyone help me with this one??



You have a large amount of 'raw' data on a worksheet (sheet1) and you wish to produce summary information tables on a new worksheet (sheet2). One of these elements of data is on sheet 1 in cell A3. How do you refer to this data on a cell on sheet 2 if you wish to display the value (using the =Value() function) which is originally calulated on sheet 1?


a. =Value(Sheet1.A3)
b. =Value(Sheet1!A3)
c. = Value(Sheet1:A3)
d. =Val(Sheet1!A3)


Thanks for any help and Merry Christmas

GJ

[pinmaster]

one way to find out is to try them yourself!

(B)

JG

[Deadloss]

Hi

Yeah, I tried 'doing them' to find the answers- however, Excel is still pretty alien to me (Im only just starting out!). Its Hard to get in the swing as it were!

Thanks for the help, I appreciate it.