Posted to microsoft.public.excel.misc

Paul P

Posts: n/a

Can I create a formula with more than 8 IF statements?

I have created the following formula:

=IF(Q12=94,"5.7",IF(Q12=86,"5.3",IF(Q12=78,"5.0 ",IF(Q12=69,"4.7",IF(Q12=59,"4.3",IF(Q12=49,"4. 0",IF(Q12=41,"3.7",IF(Q12=21,"3.0",2))))))))

but I really want to add one or two more IF statements. It does not seem to
be possible.

Any suggestions

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
How can I create a formula for Salutation	cs_vision	Excel Discussion (Misc queries)	6	October 8th 05 12:31 AM
Create Formula for calculating Little League Age...	Brent	Excel Worksheet Functions	1	September 21st 05 01:19 AM
How to create specific formula	STS	Excel Worksheet Functions	4	May 2nd 05 01:44 AM
Create formula	Leo	Excel Worksheet Functions	2	January 19th 05 10:16 PM
How do I create a formula in Excel that will countif or sumif bef.	bkclark	Excel Worksheet Functions	4	November 10th 04 05:30 PM

All times are GMT +1. The time now is 10:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us