FORMULAS THAT CAN HAVE DIFFERENT ANSWERS DEPENDING ON DATA INPUT
 

I am hoping that someone can help me out. I want to create a formula or
function that will do basically this

If I put a certain number into a cell (e6), then depending on what number I
put in that cell the corresponding number will appear into another cell (f6).

Basically ............. if I say 322 in e6, then 149 will appear in f6 or if
I put 311 in e6, then 99 will appear in f6 and so on.

Can someone please help me out??

FORMULAS THAT CAN HAVE DIFFERENT ANSWERS DEPENDING ON DATA INPUT
 

In f6
=e6
--
Don Guillett
SalesAid Software

"Dawn" wrote in message
...
I am hoping that someone can help me out. I want to create a formula or
function that will do basically this

If I put a certain number into a cell (e6), then depending on what number
I
put in that cell the corresponding number will appear into another cell
(f6).

Basically ............. if I say 322 in e6, then 149 will appear in f6 or
if
I put 311 in e6, then 99 will appear in f6 and so on.

Can someone please help me out??

FORMULAS THAT CAN HAVE DIFFERENT ANSWERS DEPENDING ON DATA INPUT
 

Use the VLOOKUP function.
A tutorial can be found he

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dawn" wrote in message ...
|I am hoping that someone can help me out. I want to create a formula or
| function that will do basically this
|
| If I put a certain number into a cell (e6), then depending on what number I
| put in that cell the corresponding number will appear into another cell (f6).
|
| Basically ............. if I say 322 in e6, then 149 will appear in f6 or if
| I put 311 in e6, then 99 will appear in f6 and so on.
|
| Can someone please help me out??

FORMULAS THAT CAN HAVE DIFFERENT ANSWERS DEPENDING ON DATA INPUT
 

I mis-read

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
In f6
=e6
--
Don Guillett
SalesAid Software

"Dawn" wrote in message
...
I am hoping that someone can help me out. I want to create a formula or
function that will do basically this

If I put a certain number into a cell (e6), then depending on what number
I
put in that cell the corresponding number will appear into another cell
(f6).

Basically ............. if I say 322 in e6, then 149 will appear in f6 or
if
I put 311 in e6, then 99 will appear in f6 and so on.

Can someone please help me out??

FORMULAS THAT CAN HAVE DIFFERENT ANSWERS DEPENDING ON DATA INPUT
 

Dawn

You can put into cell f6 either of the following formulas and it will
do basiclly what you asked:

=50/11*e6-1314.636363
or
=IF(e6=322,149,IF(e6=311,99,"who knows?"))

Of course their are lots of other formulas that will work as well. I
think if you explain a little more about the relationship between e6
and f6 someone in this group will give you an answer that will work for
you.

Good luck.

Ken
Norfolk, Va


Niek Otten wrote:
Use the VLOOKUP function.
A tutorial can be found he

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dawn" wrote in message ...
|I am hoping that someone can help me out. I want to create a formula or
| function that will do basically this
|
| If I put a certain number into a cell (e6), then depending on what number I
| put in that cell the corresponding number will appear into another cell (f6).
|
| Basically ............. if I say 322 in e6, then 149 will appear in f6 or if
| I put 311 in e6, then 99 will appear in f6 and so on.
|
| Can someone please help me out??