Forum Discussion

Copper Contributor

Jun 09, 2020

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...

excel

Formulas and Functions

mathetes

Silver Contributor

Jun 09, 2020

amangar

Do you have the IFS function? That's probably the easiest.

=IFS(ABS(C7-D7)<=5,5,ABS(C7-D7)<=10,3,ABS(C7-D7)<=15,1,ABS(C7-D7)>15,0)

If this doesn't work for you, or if you don't have the IFS function available, come back and re-ask.