| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Syntax for "Any Value"
Is there something you can type into a formula that signifies "anything at
all". In other words I need to enter a formula that when any number, date, text, or whatever it may be is typed into A1, then B1=10. Thanks for the help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Syntax for "Any Value"
hi
put this formula in B1. =if(A1="","",10) so long as a1 is empty, B1 will show null. put something in a1 and b1 = 10. regards FSt1 "SoupNazi" wrote: Is there something you can type into a formula that signifies "anything at all". In other words I need to enter a formula that when any number, date, text, or whatever it may be is typed into A1, then B1=10. Thanks for the help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Syntax for "Any Value"
Wow! The perfect solution. Thanks for the quick response.
"FSt1" wrote: hi put this formula in B1. =if(A1="","",10) so long as a1 is empty, B1 will show null. put something in a1 and b1 = 10. regards FSt1 "SoupNazi" wrote: Is there something you can type into a formula that signifies "anything at all". In other words I need to enter a formula that when any number, date, text, or whatever it may be is typed into A1, then B1=10. Thanks for the help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Syntax for "Any Value"
your welcome
FSt1 "SoupNazi" wrote: Wow! The perfect solution. Thanks for the quick response. "FSt1" wrote: hi put this formula in B1. =if(A1="","",10) so long as a1 is empty, B1 will show null. put something in a1 and b1 = 10. regards FSt1 "SoupNazi" wrote: Is there something you can type into a formula that signifies "anything at all". In other words I need to enter a formula that when any number, date, text, or whatever it may be is typed into A1, then B1=10. Thanks for the help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Syntax to "OR" 3 "ISERROR" conditions | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| disregard 12/19/05 ".XValues syntax problem" question. Answer fou | Charts and Charting in Excel | |||
| what is syntax for if(between range of dates,"Q1","Q2")? | Excel Worksheet Functions | |||
Linear Mode
