Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 17th 06, 12:12 AM posted to microsoft.public.excel.worksheet.functions
Neo1
 
Posts: n/a
Default Changing other fields using IF Function!?


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 "3000" 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 "mars" 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: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=501876


  #2   Report Post  
Old January 17th 06, 12:28 AM posted to microsoft.public.excel.worksheet.functions
Govind
 
Posts: n/a
Default Changing other fields using IF Function!?

Hi,

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

Type in

=IF(A1=3000,"Mars","")

where A1 is the cell which has got the value.

Regards

Govind.

Neo1 wrote:

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 "3000" 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 "mars" which is in part of
the list... How could I do this if its possible?

Thanks for your time
From John Wood


  #3   Report Post  
Old January 17th 06, 01:03 AM posted to microsoft.public.excel.worksheet.functions
Neo1
 
Posts: n/a
Default Changing other fields using IF Function!?


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: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=501876

  #4   Report Post  
Old January 17th 06, 03:56 AM posted to microsoft.public.excel.worksheet.functions
Arla
 
Posts: n/a
Default Changing other fields using IF Function!?

You 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

"Neo1" wrote:


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: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=501876


  #5   Report Post  
Old January 17th 06, 09:09 AM posted to microsoft.public.excel.worksheet.functions
Neo1
 
Posts: n/a
Default Changing other fields using IF Function!?


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: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=501876



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Completing Fields but not changing later... jturmel Excel Discussion (Misc queries) 1 October 6th 05 07:42 PM
changing font style in a complex worksheet function gvm Excel Worksheet Functions 6 August 3rd 05 01:29 AM
changing type style and colour within a worksheet function gvm Excel Worksheet Functions 0 July 25th 05 03:03 AM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


All times are GMT +1. The time now is 10:58 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017