Hi All,
I am making a scorecard, and if a cell is above 30%, I want the cell next to it to score 5 points, and if the cell is below 30%, I want it to score 2 points. Is this possible?
I have attached a spreadsheet to show you the layout.
Many thanks
Bookmarks