User Profile
amangar
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: IF function with calculation based on other cell
mathetes I put the space on purpose when I was taking a screenshot to show the formula. I know that would stop the formula from working lol. I ended up with the following formulas, but I wondered if they could be simpler. The criteria tab says what each formula should be based on for the scorecard.IF function with calculation based on other cell
I am looking to use the IF function that produces a 1, 3, or 5 in E5 based on C1 based on the following criteria: if D7 is within 5 points of C7, then E7 should be 5 (i.e., 5 points greater than 60.8 or 5 points less than 60.8) if D7 is within 10 points of C7, then E7 should be 3 (i.e., 10 points greater than 60.8 or 10 points less than 60.8) if D7 is within 15 points of C7, then E7 should be 1 (i.e., 15 points greater than 60.8 or 15 points less than 60.8) I'm not sure how to do this given that its a range of greater or less than data in one IF statement.
