Mar 25, 2014
I am compiling a spreadsheet to determine various membership levels of Regular, Bronze, Silver, and Gold, which is based on the number of volunteer events attended at our organization (cell A1), as well as the level of giving (cell B1). Regular is the lowest level, and Gold is the highest.
View 9 Replies
Now let's say that I am looking for a formula that will be entered into cell C1. This formula would read cell A1 and cell B1, and then return the value that is the higher value. So, let's say the formula in cell A1 returned the value "Silver" and the cell B1 returned the value "Gold", ultimately, the formula in cell C1 would read these two cells, make the determination that the value "Gold" is the higher value, and return "Gold" in cell C1.