Thread: IF formula not working

Dear anybodywhocanhelp,

I have a problem I can not solve.
I have an IF formula that depends on an argument from another cell, that also contains IF formula, and it would not work?

Can anybody help me with this? problem attached

If you place the criteria in paranthesis it should work for you.
(Ex: B1="2"...B1="4")

Dear Laura,

Indeed it worked.
Thank you a lot, I owe you one.

Saso