Constant
 

Hi, sorry, me again :rolleyes:

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

Thanks


--
sedonovan
------------------------------------------------------------------------
sedonovan's Profile: http://www.excelforum.com/member.php...o&userid=35626
View this thread: http://www.excelforum.com/showthread...hreadid=554455

Constant
 

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","")

sedonovan Wrote:
Hi, sorry, me again :rolleyes:

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

Thanks


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=554455

Constant
 

thanks, you ARE a star!


--
sedonovan
------------------------------------------------------------------------
sedonovan's Profile: http://www.excelforum.com/member.php...o&userid=35626
View this thread: http://www.excelforum.com/showthread...hreadid=554455

Constant
 

"starguy" wrote in
message ...
sedonovan Wrote:
Hi, sorry, me again :rolleyes:

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

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","")

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.
--
David Biddulph

Constant
 

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

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

Drop the quotes for numbers, otherwise it'll be returned as text numbers
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Constant
 

yes

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

Drop the quotes for numbers, otherwise it'll be returned as text
numbers
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=554455