Posted to microsoft.public.excel.misc

Posts: n/a

Problem with IF function

Hello,

I get a name error when I try to use this formula:

=IF(A4="Q1",U10,IF(A4="Q2",U11,IF(A4="Q3",U12,IF(A 4="Q4",U13, Error))))

where cell A4 contains text. If the text begins with "Q1", which means
Quarter 1, then I want it to return the value that is in cell U10. The
actual text shown in cell A4 is "Q1-86" for Quarter 1 1986.

Any help would be greatly appreciated.

Thanks,

Gary

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
LOOKUP function problem?	DORI	Excel Worksheet Functions	0	November 27th 05 11:45 PM
function problem regarding cell range	chindo	Excel Worksheet Functions	1	November 10th 05 03:06 AM
Lookup function problem (kg)	greencecil	Excel Worksheet Functions	3	July 1st 05 04:54 PM
Problem with function "Worksheet_Change"	konpego	Excel Worksheet Functions	0	June 23rd 05 05:46 AM
Problem adding a range using Sumif function.	vrk1	Excel Worksheet Functions	2	June 22nd 05 06:05 PM

All times are GMT +1. The time now is 03:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us