Menu

FORMULAS THAT CAN HAVE DIFFERENT ANSWERS DEPENDING ON DATA INPUT

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.worksheet.functions

Don Guillett Don Guillett is offline

Don Guillett is offline

external usenet poster

Posts: 10,124

Default

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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Manual control of link updating for downloaded quotes?	dk_	Excel Discussion (Misc queries)	9	November 15th 06 01:04 PM
How to Prevent Duplicate Data from inputing using input application?	Zigball	Excel Worksheet Functions	8	October 16th 06 11:01 PM
How to Prevent Duplicate Data from inputing using input application?	Zigball	Excel Discussion (Misc queries)	1	October 10th 06 05:56 PM
How to Prevent Duplicate Data from inputing using input application?	Zigball	New Users to Excel	1	October 10th 06 05:31 PM
Excel 2002; copy formulas to one workbook to another diff data	SinnetBS	Excel Worksheet Functions	1	November 25th 05 08:31 PM

All times are GMT +1. The time now is 07:50 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement