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