Constant

Hi, sorry, me again

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

Thanks

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

Originally Posted by sedonovan

Hi, sorry, me again

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

Thanks

thanks, you ARE a star!

> =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
---

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
---[/QUOTE]

"starguy" <[email protected]> wrote in
message news:[email protected]...
> sedonovan Wrote:
>> Hi, sorry, me again
>>
>> 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