|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 9th, 2005, 04:21 AM
|
|||
|
|||
IF Function??
What can I do so that when I type a certain number in a column it will give me another number? For example I have a list of temperature correction factors ranging from 60 to 89 degrees and I would like to be able to input the temperature in one column and have excel input the correction factor in another column. Can anyone help? -- DBassmaker ------------------------------------------------------------------------ DBassmaker's Profile: http://www.excelforum.com/member.php...o&userid=27097 View this thread: http://www.excelforum.com/showthread...hreadid=466143 
|
|
#2
September 9th, 2005, 05:15 AM
|
|||
|
|||
|
One possible way
http://www.contextures.com/xlFunctions02.html -- Regards, Peo Sjoblom (No private emails please) "DBassmaker" wrote in message news  What can I do so that when I type a certain number in a column it will give me another number? For example I have a list of temperature correction factors ranging from 60 to 89 degrees and I would like to be able to input the temperature in one column and have excel input the correction factor in another column. Can anyone help? -- DBassmaker ------------------------------------------------------------------------ DBassmaker's Profile: http://www.excelforum.com/member.php...o&userid=27097 View this thread: http://www.excelforum.com/showthread...hreadid=466143
|
|
#3
September 9th, 2005, 05:24 AM
|
|||
|
|||
|
Please check reply in your other post. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=466143
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| SPELL CURRENCY FUNCTION | Rajesh | Using Forms | 1 | October 1st, 2005 11:04 PM |
| Attaching Code | DS | General Discussion | 2 | August 22nd, 2005 11:21 PM |
| Embedded Application Icon | Irshad Alam | General Discussion | 5 | April 5th, 2005 02:16 PM |
| Need a ISWorkday Function -- Any Ideas | Mark | Worksheet Functions | 5 | March 29th, 2005 01:58 AM |
| UK postcode issue | Lapchien | Running & Setting Up Queries | 6 | June 11th, 2004 09:06 PM |
Linear Mode
