Hello, I haven't used the IF function in years so I need some help, please.
Here is my data - Condition; A-E, and Priority 0-9
If I want to add a rule that says if the condition is A, the priority must be 9, how do I do this? The other conditions don't require a rule so the false criteria needs to be left blank - it's this bit that I'm struggling with - is this possible?
Any help would be amazing - thanks!
