Syntax for "Any Value"

S

SoupNazi

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.
 
F

FSt1

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
 
Top