Posted to microsoft.public.excel.misc

Jeremy

external usenet poster

Posts: 85

Nested If

I need some help creating a nested if formula. The goal is to get a score 0
through 5 for different parameters.

Condition Result (Score)
S83=0 0
S83<=AD83 5
S83AD83<=AC83 4
S83AC83<=AB83 3
S83AB83<=Z83 2
S83Z83 1

Does this make sense?

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
nested ifs not enough	Vincent	Excel Discussion (Misc queries)	1	August 23rd 07 03:58 PM
nested if based on nested if in seperate sheet. how?	scouserabbit	Excel Worksheet Functions	5	March 2nd 07 04:03 PM
More than 16 nested IFs!!!!	Meltad	Excel Worksheet Functions	11	October 6th 06 09:49 AM
Nested Ifs	Sal	Excel Worksheet Functions	5	April 16th 06 10:43 AM
Run out of nested Ifs	Clive Williamson	Excel Worksheet Functions	8	April 10th 06 12:36 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us