| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how excel checks a "#" to express it as a text, check if cell is n
basically to check if a cell is a "number" and say yes it is true - "number"
.. i don't know how how to write the syntax to result a text from a cell that is a number to a cell that is a text and is dependent on another cell: a1= time b1=text b1 reffres to a1, then: c1=number that will change the text in b1 to a different text. I know i have to add a function in b1 that will express c1 but how do I write the function if i am referring to a number inside cell c1. what expression is for excel to check if it is a #? In another words, I just need to check if the cell b1 is a number then in c1 i will write my text that i want. thanx for the answer Bee |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how excel checks a "#" to express it as a text, check if cell is n
In another words, I just need to check if the cell
b1 is a number then in c1 i will write my text that i want. =ISNUMBER(B1) Will return either TRUE or FALSE -- Biff Microsoft Excel MVP "kbee" wrote in message ... basically to check if a cell is a "number" and say yes it is true - "number" . i don't know how how to write the syntax to result a text from a cell that is a number to a cell that is a text and is dependent on another cell: a1= time b1=text b1 reffres to a1, then: c1=number that will change the text in b1 to a different text. I know i have to add a function in b1 that will express c1 but how do I write the function if i am referring to a number inside cell c1. what expression is for excel to check if it is a #? In another words, I just need to check if the cell b1 is a number then in c1 i will write my text that i want. thanx for the answer Bee |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how excel checks a "#" to express it as a text, check if cell
thank you .
"T. Valko" wrote: In another words, I just need to check if the cell b1 is a number then in c1 i will write my text that i want. =ISNUMBER(B1) Will return either TRUE or FALSE -- Biff Microsoft Excel MVP "kbee" wrote in message ... basically to check if a cell is a "number" and say yes it is true - "number" . i don't know how how to write the syntax to result a text from a cell that is a number to a cell that is a text and is dependent on another cell: a1= time b1=text b1 reffres to a1, then: c1=number that will change the text in b1 to a different text. I know i have to add a function in b1 that will express c1 but how do I write the function if i am referring to a number inside cell c1. what expression is for excel to check if it is a #? In another words, I just need to check if the cell b1 is a number then in c1 i will write my text that i want. thanx for the answer Bee |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how excel checks a "#" to express it as a text, check if cell
You're welcome!
-- Biff Microsoft Excel MVP "kbee" wrote in message ... thank you . "T. Valko" wrote: In another words, I just need to check if the cell b1 is a number then in c1 i will write my text that i want. =ISNUMBER(B1) Will return either TRUE or FALSE -- Biff Microsoft Excel MVP "kbee" wrote in message ... basically to check if a cell is a "number" and say yes it is true - "number" . i don't know how how to write the syntax to result a text from a cell that is a number to a cell that is a text and is dependent on another cell: a1= time b1=text b1 reffres to a1, then: c1=number that will change the text in b1 to a different text. I know i have to add a function in b1 that will express c1 but how do I write the function if i am referring to a number inside cell c1. what expression is for excel to check if it is a #? In another words, I just need to check if the cell b1 is a number then in c1 i will write my text that i want. thanx for the answer Bee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
| Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
| Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Hybrid Mode
