Forum Discussion
Help with IF statement
HI OPS-MLTSD
You need to revisit the range of 'IHSP - work plan'[3-Yr LTI per 100]
as per your formula
>=5 High <1 Low >=1(is it 'and <2'?????) Medium >=2 to <5(Ths range is not present) ???????(lets assume Medium High) Try this
3 Yr LTI Risk = IF('IHSP - work plan'[3-Yr LTI per 100] >=5, "High",
IF('IHSP - work plan'[3-Yr LTI per 100] <1, "Low",
IF('IHSP - work plan'[3-Yr LTI per 100] >=1 && 'IHSP - work plan'[3-Yr LTI per 100] <2, "Medium",IF('IHSP - work plan'[3-Yr LTI per 100] >=2 && 'IHSP - work plan'[3-Yr LTI per 100] <5,"Medium High",
"Not Available")
)
)
)
Did I resolve your issue? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!!
Regards,
Pranit
HI OPS-MLTSD
You need to revisit the range of 'IHSP - work plan'[3-Yr LTI per 100]
as per your formula
| >=5 | High |
| <1 | Low |
| >=1(is it 'and <2'?????) | Medium |
| >=2 to <5(Ths range is not present) | ???????(lets assume Medium High) |
Try this
3 Yr LTI Risk = IF('IHSP - work plan'[3-Yr LTI per 100] >=5, "High",
IF('IHSP - work plan'[3-Yr LTI per 100] <1, "Low",
IF('IHSP - work plan'[3-Yr LTI per 100] >=1 && 'IHSP - work plan'[3-Yr LTI per 100] <2, "Medium",
IF('IHSP - work plan'[3-Yr LTI per 100] >=2 && 'IHSP - work plan'[3-Yr LTI per 100] <5,"Medium High",
"Not Available")
)
)
)
Did I resolve your issue? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!!
Regards,
Pranit
Thank you, I tried your formula, however, I noticed that it is not applying to the decimal values; for example - 5.69 should be considered "High" but the category I am getting for 5.69 is "Not Available, if you could please let me know how I can resolve this, that would be much appreciated!
Hi OPS-MLTSD ,
Works for 5.69 using the same formula.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)