Constant

S

sedonovan

Hi, sorry, me again :rolleyes:

is there a way to make a constant value in one cell automatically, i
another cell on that row has been populated.

Thank
 
S

starguy

suppose you want a constant say 100 to be put in col B if col A (in sam
row) is populated i-e not empty
try this formula (put it in cell B1 and copy it down)
=IF(A1<>"","100","")
 
D

David Biddulph

suppose you want a constant say 100 to be put in col B if col A (in same
row) is populated i-e not empty
try this formula (put it in cell B1 and copy it down)
=IF(A1<>"","100","")
Click to expand...

But make that
=IF(A1<>"",100,"") if you want to use the 100 as a number. With "100" in
the double quotes it would appear as a text string.
 
M

Max

=IF(A1<>"","100","")

Believe starguy meant:
=IF(A1<>"",100,"")

Drop the quotes for numbers, otherwise it'll be returned as text numbers
 
S

starguy

yes

Believe starguy meant:
=IF(A1<>"",100,"")

Drop the quotes for numbers, otherwise it'll be returned as text
numbers
 
Top