software

Hello, I have a question which seems to be puzzling, I want to set a
formula in which if a certain cell reaches for example quot;3000quot; i want it
to change another cell in the spreadsheet this cell is a drag and drop
cell in which it has options so for instance if a cell reaches 3000 i
want it to change the drag and drop cell to quot;marsquot; which is in part of
the list... How could I do this if its possible?

Thanks for your time
From John Wood--
Neo1
------------------------------------------------------------------------
Neo1's Profile: www.excelforum.com/member.php...oamp;userid=30329
View this thread: www.excelforum.com/showthread...hreadid=501876Hi,

Go to the cell, which you want to change to mars.

Type in

=IF(A1gt;=3000,quot;Marsquot;,quot;quot;)

where A1 is the cell which has got the value.

Regards

Govind.

Neo1 wrote:

gt; Hello, I have a question which seems to be puzzling, I want to set a
gt; formula in which if a certain cell reaches for example quot;3000quot; i want it
gt; to change another cell in the spreadsheet this cell is a drag and drop
gt; cell in which it has options so for instance if a cell reaches 3000 i
gt; want it to change the drag and drop cell to quot;marsquot; which is in part of
gt; the list... How could I do this if its possible?
gt;
gt; Thanks for your time
gt; From John Wood
gt;
gt;


But the cell i want it to be changed to mars is a drop and down list
with all items and in it includes mars too i want to find a way to
change that cell to display mars automatically when some other cell
reaches 3000...

Thanks for your time
From John Wood--
Neo1
------------------------------------------------------------------------
Neo1's Profile: www.excelforum.com/member.php...oamp;userid=30329
View this thread: www.excelforum.com/showthread...hreadid=501876You said it was a drop down list? How many items are in this drop down list
and when do you use those items, and on what conditions? Maybe you need to
use a conditional format?
Arla

quot;Neo1quot; wrote:

gt;
gt; But the cell i want it to be changed to mars is a drop and down list
gt; with all items and in it includes mars too i want to find a way to
gt; change that cell to display mars automatically when some other cell
gt; reaches 3000...
gt;
gt; Thanks for your time
gt; From John Wood
gt;
gt;
gt; --
gt; Neo1
gt; ------------------------------------------------------------------------
gt; Neo1's Profile: www.excelforum.com/member.php...oamp;userid=30329
gt; View this thread: www.excelforum.com/showthread...hreadid=501876
gt;
gt;


Still haven't developed the spreadsheet with the formula but ive written
down in theory...the drop down list i suppose will have three items,
mars, coke and fanta

It's basically what i stated above..

Thanks for your time

From John Wood--
Neo1
------------------------------------------------------------------------
Neo1's Profile: www.excelforum.com/member.php...oamp;userid=30329
View this thread: www.excelforum.com/showthread...hreadid=501876