View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dawn Dawn is offline
external usenet poster
 
Posts: 80
Default 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??