Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-06-2016, 02:00 PM
TDWolsey TDWolsey is offline Nested IF Windows 10 Nested IF Office 2010 32bit
Novice
Nested IF
 
Join Date: Jan 2016
Posts: 2
TDWolsey is on a distinguished road
Post Nested IF


Hi, I searched a bit and didn't see this question, so here goes:

I want to create a nested IF formula that associates a raw score/number with a specific proficiency level; that is, if a score is 23, it should be assigned a proficiency level of 5. If the score is 22, it should be assigned a proficiency level of 4, and so on.

Here is the formula I used: =IF(K14>10,"1",IF(K14>15,"2",IF(K14>19,"3",IF(K14> 23,"4",IF(K14<26,"5")))))
No go.
So I reversed it: =IF(K14>26,"5",IF(K14>23,"4",IF(K14>19,"3",IF(K14> 15,"2",IF(K14<10,"1")))))
Still no go.

I attached a screen shot of the page. Any thoughts on how to create a cascading or nested IF (or maybe another) statement?

The green shaded areas include the overall score (tallied from each column using COUNTA) and the Proficiency level.

Thanks!
Attached Images
File Type: jpg SOLOM Screencap.JPG (85.3 KB, 20 views)
Reply With Quote
 

Tags
nested



Similar Threads
Thread Thread Starter Forum Replies Last Post
nested if and averageA windseaker Excel 0 08-14-2015 04:13 PM
Nested IF using if and nested vlookup wentworth16238 Excel 5 06-14-2015 12:59 PM
Nested Countif Function bdavidson22 Excel 0 12-19-2014 12:36 PM
Nested Vlookup Help asluder2000 Excel 2 11-14-2014 11:00 PM
Nested IF Nested IFs JimS378 Excel 7 05-03-2011 08:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft