Mackbear
Registered User.
- Local time
- Today, 05:24
- Joined
- Apr 2, 2019
- Messages
- 168
Hello everyone, good day! I hope you're all doing fine.
So I have this formula because of your help guys and I need to add another condition that will ignore these conditions if the condition is met.
This one determines the priority based on Age, however I need to have it ignore this based on a content of a different field not on Age. I don't know how to structure it... hope you can help me
IIf([Age]<=-2,"Emergency",IIf([Age]<=0,"Critical",IIf([Age]<=2,"High",IIf([Age]<=5,"Medium",IIf([Age]>=6,"Low","No Date")))))
Thank you everyone in advance!
So I have this formula because of your help guys and I need to add another condition that will ignore these conditions if the condition is met.
This one determines the priority based on Age, however I need to have it ignore this based on a content of a different field not on Age. I don't know how to structure it... hope you can help me
IIf([Age]<=-2,"Emergency",IIf([Age]<=0,"Critical",IIf([Age]<=2,"High",IIf([Age]<=5,"Medium",IIf([Age]>=6,"Low","No Date")))))
Thank you everyone in advance!