IF Function Help

Occasional Visitor

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!

1 Reply
Hi Stacey,

Could you please share a file containing a sample of your spreadsheet or a screen of it?