Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 1

Multi IF function not working

How do I get this type of formula to work without it giving me a "Too many
arguments for this function" error:

=IF(B21=14,B3/2,0,IF(B21=15,C3/2,0,IF(B21=16,D3/2,0,IF(B21=17,E3/2,0,IF(B21=18,F3/2,0,IF(B21=19,G3/2,0,IF(B21=20,H3/2,0)))))))

Is there another Function I can use?
--
IT1 Navy

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
Which function/s should be used on a multi conditional formula?	Chuck	Excel Discussion (Misc queries)	4	January 6th 09 10:19 PM
Multi Function for Unique Numbers	Amber	Excel Worksheet Functions	4	May 15th 07 09:56 PM
multi function cells	kellerfro	Excel Discussion (Misc queries)	4	June 27th 05 07:34 PM
Multi-If function	Stefano	Excel Worksheet Functions	1	April 2nd 05 11:49 AM
How do I create a multi formula IF function in Excel?	Wazza	Excel Worksheet Functions	8	November 8th 04 09:25 PM

All times are GMT +1. The time now is 12:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us