Anyway, what I'm trying to do is write a formula so that if the absolute value of an operation comes out within a certain number range, it will output a specific other number. For example, if I do ABS of the operation, and the answer is between 0 and 4, then output 5, if between 5 and 8, output 4, and so on. That number should then also be added to the largest of a set of cells, but that part is working fine. I think the IF statements are okay, based on other usages I've seen, I just can't find the proper format for checking the number range of the ABS output.
Here's what I have right now. I've tried [0,4], [0;4], [0:4], and with () instead of []. I think there's something else missing as well.
Code: Select all
=LARGE(G8:G10; 1)+IF(ABS(G8-G9)=[0:4];5;IF(ABS(G8-G9)=[5:8];4;IF(ABS(G8-G9)=[9:14];3;IF(ABS(G8-G9)=[15:20];2;IF(ABS(G8-G9)=[21:26];1;0)))))