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.

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.

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.

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.