=IF(AND(H101>N96,H101<=N97),140-((H101-N96)/(N97-N96))*2.5,IF(AND(H101>N97,H101<=N98),137.5-((H101-N97)/(N98-N97))*2.5,IF(AND(H101>N98,H101<=N99),135-((H101-N98)/(N99-N98))*2.5,IF(AND(H101>N99,H101<=N100),132.5-((H101-N99)/(N100-N99))*2.5,IF(AND(H101>N100,H101<=N101),130-((H101-N100)/(N101-N100))*2.5,IF(AND(H101>N101,H101<=N102),127.5-((H101-N101)/(N102-N101))*2.5,IF(AND(H101>N102,H101<=N103),125-((H101-N102)/(N103-N102))*2.5,IF(AND(H101>N103,H101<=N104),122.5-((H101-N103)/(N104-N103))*2.5,IF(AND(H101>N104,H101<=N105),120-((H101-N104)/(N105-N104))*2.5,IF(AND(H101>N105,H101<=N106),117.5-((H101-N105)/(N106-N105))*2.5,IF(AND(H101>N106,H101<=N107),115-((H101-N106)/(N107-N106))*2.5,IF(AND(H101>N107,H101<=N108),112.5-((H101-N107)/(N108-N107))*2.5,IF(AND(H101>N108,H101<=N109),110-((H101-N108)/(N109-N108))*2.5,IF(AND(H101>N109,H101<=N110),107.5-((H101-N109)/(N110-N109))*2.5,IF(AND(H101>N110,H101<=N111),105-((H101-N110)/(N111-N110))*2.5,IF(AND(H101>N111,H101<=N112),102.5-((H101-N111)/(N112-N111))*2.5,IF(AND(H101>N112,H101<=N113),100-)))))))))))))))))

Edit: Changed subject, was avoiding an error in calc Make your post understandable by others -- MrProgrammer, forum moderator |