Someone Help Me with =IF(AND(X,Y),T, F) Function

Question

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.&nbsp; Here's a sample:&nbsp;=IF(AND(C17&gt;3,D17&gt;3),TRUE, FALSE)&nbsp; &nbsp;where C17=1 and D17=2&nbsp; &nbsp;returns "TRUE"BUT=IF(AND(C19&lt;3,D19&lt;3),TRUE, FALSE)&nbsp; &nbsp;where C19=1 and C19=5&nbsp; &nbsp;returns "TRUE"&nbsp;This happens when the inverse is true as well, so I'm pretty sure it has something to do with the formula phrasing itself.&nbsp;&nbsp;&nbsp;Thanks!@

welbermohamad · Answer

BrieHuggerHello,i did tests on previous versions (2010) and your formula worked perfectly&nbsp;&nbsp;

patrick2788 · Answer

BrieHugger&nbsp;There's a possibility your 'numbers' are being evaluated as 'text'.&nbsp; You could try using this function on any of your numbers.&nbsp;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

Forum Discussion

Someone Help Me with =IF(AND(X,Y),T, F) Function

Share

Resources