if-statement: IF Function with multiple statements - If cell contains "0" = "BE", If cell is greater than "0" = "W", If cell is less than "0" = "L"

mardi 23 mars 2021

I'm having trouble trying to get this formula to work.

I have been using this formula =IF(A2="0","BE",IF(A3<=0,"L",IF(A4>=1,"W"))) But it seems something is wrong as it's not returning the correct values.

So basically, If a cell contains "0" i need it to return "BE" - Above "0" i need it to return "W" & Below "0" i need it to return "L"

I hope this makes sense!

Thank you in advance! :)

if-statement