NEED HELP WITH EXCEL FORMULA

Copper 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