Trying to compare three values in excel -


i have table, , i'm trying value if 1 value in between 2 other values. want pull percentages come numbers have top numbers in between them. @ image better picture if needed. =if(c7<=d6<=c8,d8,if(c8<=d6<=c9,d9,if(c9<=d6<=c10,d10,if(c10<=d6<=c11,d11,if(c11<=d6<=c12,d12,if(c12<=d6<=c13,d13,0))))))

this picture shows table.


Comments