mardi 31 mai 2016

VBA function for multiple Ifs for multiple outcomes

I'm very new to the VBA functions/anything above basic user level computers. I'm trying to create a function in excel that returns a value (there are five values that the ratings can equate to) based on its rating in six different areas(or cells). Trying to auto populate the rating of a company based on the 6 different criteria.

Example If G34 > 84.99%, J34 >79.99%, K34 ="Yes" Then "T" but If G34 < 84.99%, J34 >79.99%, and K34 ="No" Then "T-". I've been trying an ElseIf statement but keep running into issues. Help is very appreciated!!!

Below is the very elementary full function that I'm trying to get:

IF(G34>84.99%, J34>79.99%, K34="Yes", M34 >89.99%, N34 = 100%, O34>89.99%, Then "T", 
IF(G34>74.99%, G34<84.99%, J34>79.99%, K34 = "Yes", M34 >79.99%, M34 <89.99%, N34 = 100%, O34 <89.99%, O34>79.99%, Then "T-", 
IF(G34>64.99%, G34<74.99%, J34<79.99%, G34 > 74.99%, K34 = "NO", M34 >64.99%, M34 <79.99%, N34 = 100%, O34 <89.99%, O34>79.99%, Then "P", 
IF(G34>59.99%, G34<64.99%, J34<74.99%, J34 > 59.99%, K34 = "NO", M34 >49.99%, M34 <64.99%, N34 < 100%, O34 < 79.99%, Then "P-", 
IF(G34<59.99%, J34<59.99%, K34 = "NO", M34 <49.99%, N34 < 100%, O34 < 79.99%, Then "U")))))   

Aucun commentaire:

Enregistrer un commentaire