amy

Posts: n/a

simple if then function

I know this should be simple but I am having problems
if f9=xa then f20=133
if f9=tc then f20=168
if f9=xb then f20= 145

I had done these years ago and just can't get this simple formula to work.
Any help you can give me would be greatly appreciated.

Thank you

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Excel option to store trendline's coefficients in cells for use	Miguel Saldana	Charts and Charting in Excel	9	June 20th 05 08:45 PM
Date & Time	mully	New Users to Excel	4	May 23rd 05 11:56 AM
Automatically up date time in a cell	Mark	Excel Discussion (Misc queries)	5	May 12th 05 12:26 AM
clock	Wildman	Excel Worksheet Functions	2	April 26th 05 10:31 AM
Excel should have a quick and simple "change case" function like .	NinaSvendsen	Excel Worksheet Functions	1	January 28th 05 03:15 PM

All times are GMT +1. The time now is 04:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us