Forum Discussion
Someone Help Me with =IF(AND(X,Y),T, F) Function
Hey all, I'm just trying to get an If/And function working, and it seems like I do - However when I apply the equation to different numbers, it's incorrect. Here's a sample: =IF(AND(C17>3,D17>3...
There's a possibility your 'numbers' are being evaluated as 'text'. You could try using this function on any of your numbers.
For example:
=ISNUMBER(C19)If the above check results in FALSE, you might explore a solution offered here:
Convert numbers stored as text to numbers - Microsoft Support