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

For issues 1 & 2:

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

--
Gary''s Student - gsnu200779


"pierre" wrote:

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

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" wrote:

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

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.


"
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

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

"pierre" wrote:

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.


"
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