Is there a way that I can assign a value to "apple" (has a value of 3) and "orange" (has a value of 2) such that I could reference the cells they are in my formula (not write apple or orange in the formula)
Example A1 + B1 = 5 (Not Apple + Orange = 5)
Example A1 + B1 = 5 (Not Apple + Orange = 5)