Excel Nested IF

Question

Creator

Topic
September 26, 2012 at 9:52 am #2170976

Excel Nested IF

Locked

by mslwill · about 10 years, 2 months ago

Please tell me why this IF statement won’t work completely? =IF(B2=5,”Exceeds Expectations”,IF(3,”Meets Expectations”,IF(1,”Needs Improvement”,IF(” “,” “)))).The first two arguments work, but the last two do not. Can someone please advise? Thank you

This conversation is currently closed to new comments.
Creator

Topic

All Answers

Author

Replies
- September 26, 2012 at 9:52 am #2888389
  
  Clarifications
  
  by mslwill · about 10 years, 2 months ago
  
  In reply to Excel Nested IF
  
  Clarifications
- September 27, 2012 at 11:12 am #2888312
  
  Excel custom function
  
  by cleaverx · about 10 years, 2 months ago
  
  In reply to Excel Nested IF
  
  I am sorry I don’t have a ready answer for you, but you will probably have a better chance of someone good with VBA helping you out if you explain in details what exactly is that you are trying to accomplish with this formula. It just may be that the approach itself needs to be revisited.
  Best regards
  
  The Cleaver
Author

Replies

Viewing 1 reply thread

Start or Search

Start New Discussion

In order to maintain a consistent, predictable and supportable computing environment it is essential to establish a pre-defined set of software applications for use on workstations, laptops, mobile devices and servers. When employees install random or questionable software on their workstations or devices it can lead to clutter, malware infestations and lengthy support remediation. Company-approved ...

Password-driven security may not be the perfect solution, but the alternatives haven’t gained much traction. This policy defines best practices that will make password protection as strong and manageable as possible. From the policy: Employee passwords are the first line of defense in securing the organization from inappropriate or malicious access to data and services. ...

Recruiting candidates with advanced software engineering experience and a least some familiarity with applied blockchain technology will take time and effort. This hiring kit provides a workable framework you can use to find, recruit, and ultimately hire the best candidate for Blockchain Engineer in your organization. From the Hiring kit INTRODUCTION Moving well-beyond its cryptocurrency ...

Software

Question

Excel Nested IF

All Answers

Clarifications

Excel custom function

Software usage policy

Password management policy

Hiring kit: Blockchain Engineer

Cloud computing policy