issues in exxcel

[pierre]

first issue : i have in cell A1 the word (office) ...i would like to make a
formula which says : if A1 contains text (true value="okay")

second issue : i have in cell A2 the number (5) ...i would like to make a
formula which says : if A2 contains a number (true value="1000")

third issue : i would like to make a HYPERLINK for cell A3 located in
sheet3 and who may combine cell A1 in sheet1 , and cell A2 in sheet 2.......
i means that if i
ever click the hyperlink A3 , i will get the cells A1 and A2 shadowed as
references
thank you

 

[Gary''s Student]

For issues 1 & 2:

=IF(ISTEXT(A1),"okay","")
=IF(ISTEXT(A1),"","1000")

 

[FSt1]

hi
item one and two are easy.
=IF(ISTEXT(A1),"Okay","Not Okay")
=IF(ISNUMBER(A2),1000,"")
but the third part.....not sure what you mean by "shawdowed as a reference"

Regards
FSt1

 

[pierre]

i mean that if i should click the hyperlink cell A3 in sheet 3 , it should
show me the cells A2 in sheet 2 and A1 in sheet 1 .thank you.

 

[FSt1]

hi
if you want to see sheet2 A1 and A2 from sheet 2, how about a formula instead
=Sheet1!A1&" "&Sheet1!A2

this will display both in Cell A3

Regards
FSt1