Posted to microsoft.public.excel.worksheet.functions

AAA1986

external usenet poster

Posts: 16

Difficult function question for columns

Perfect! Thank you.

"David Biddulph" wrote:

=IF(A1=1,B$10,IF(A1=2,B$11,IF(A1=3,B$12,"whatever you want if it isn't any
of those")))
--
David Biddulph

"AAA1986" wrote in message
...
I would like the create a column that performs the following function:

[If column A=1, then display number in cell B10; If Column A=2, then
display
number in cell B11, If column A=3; then display number in cell B12]

If it is of any importance, in the above example B10:12 have a
=SUMIF/COUNTIF function in them.

Thanks in advance.

.

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
difficult formula question	Joann	Excel Worksheet Functions	4	October 3rd 08 09:30 PM
Graph question - difficult?	Paul	Excel Discussion (Misc queries)	1	February 29th 08 11:13 PM
Difficult ------------- question	woo	Excel Discussion (Misc queries)	1	May 6th 07 04:23 AM
difficult question	Wu	Excel Discussion (Misc queries)	2	April 1st 07 03:10 PM
Difficult Excel Question	[email protected]	Excel Discussion (Misc queries)	2	January 27th 05 12:10 PM

All times are GMT +1. The time now is 06:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us