FORMULAS THAT CAN HAVE DIFFERENT ANSWERS DEPENDING ON DATA INPUT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
Use the VLOOKUP function.
A tutorial can be found here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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??
 
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
 
Back
Top