NEED HELP WITH EXCEL FORMULA

%3CLINGO-SUB%20id%3D%22lingo-sub-1591299%22%20slang%3D%22en-US%22%3ENEED%20HELP%20WITH%20EXCEL%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1591299%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20want%20to%20do%20below%20type%20formula%20in%20column%20K%3CBR%20%2F%3Ecolumn%20I%20is%20numeric%2023.45%3C%2FP%3E%3CP%3Eand%20i%20want%20to%20do%20is%20if%20column%20L%20will%20-23.45%20so%20%22SL%22%2C%20if%20column%20L%20will%20subtract%20with%202%20is%20equal%20to%2023.45%20then%20%221%3A2%22%20and%20last%20if%20column%20L%20will%20subtract%20with%203%20is%20equal%20to%2023.45%20then%20%221%3A3%22%3CBR%20%2F%3E%3DIF(L2%3D-I2%2C%22SL%22%2CIF(L2%3DI2%2C%221%3A1%22%2CIF(L2%2F2%3DI2%2C%221%3A2%22%2CIF(L2%2F3%3DI2%2C%221%3A3%22))))%3CBR%20%2F%3Ei%20get%20only%20%22SL%22%20%2C%20%221%3A1%22%20so%3CBR%20%2F%3Ecan%20you%20help%20to%20resolve%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1591299%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1591310%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20HELP%20WITH%20EXCEL%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1591310%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F760919%22%20target%3D%22_blank%22%3E%40JASHDEEPSINH%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(L2%3D%22%22%2C%22%22%2CIF(ROUND(L2%2BI2%2C2)%3D0%2C%22SL%22%2CIF(ROUND(L2-I2%2C2)%3D0%2C%221%3A1%22%2CIF(ROUND(L2-2*I2%2C2)%3D0%2C%221%3A2%22%2CIF(ROUND(L2-3*I2%2C2)%3D0%2C%221%3A3%22%2C%22Other%22)))))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1591468%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20HELP%20WITH%20EXCEL%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1591468%22%20slang%3D%22en-US%22%3E%3CP%3Ethank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

i want to do below type formula in column K
column I is numeric 23.45

and i want to do is if column L will -23.45 so "SL", if column L will subtract with 2 is equal to 23.45 then "1:2" and last if column L will subtract with 3 is equal to 23.45 then "1:3"
=IF(L2=-I2,"SL",IF(L2=I2,"1:1",IF(L2/2=I2,"1:2",IF(L2/3=I2,"1:3"))))
i get only "SL" , "1:1" so
can you help to resolve?

2 Replies

@JASHDEEPSINH 

Perhaps

 

=IF(L2="","",IF(ROUND(L2+I2,2)=0,"SL",IF(ROUND(L2-I2,2)=0,"1:1",IF(ROUND(L2-2*I2,2)=0,"1:2",IF(ROUND(L2-3*I2,2)=0,"1:3","Other")))))

thank you @Hans Vogelaar