I am trying to get the equation to process the formula based on the status in Column B
For example Row 3 has sold 42 and their status is PT, so I want the bonus to be paid (which is B33 x F3) as the benchmark for PT is in B43 (40)
Another example Row 8 has sold 5 and their status is CAS, so I don't want the bonus to be paid as the benchmark for CAS is in B44 (20)
Sample File Attached and have highlighted the areas in YELLOW
If you see any other areas of my spreadsheet that could be improved, feel free to let me know (I'm a novice)
Thanks in advance!!
Bookmarks