View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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??