Jun 08 2019 01:18 PM
Jun 08 2019 01:31 PM
In Excel with comparing operators any logical value is always more than any text, and any text is always more than any number.
Jun 08 2019 01:42 PM
Jun 08 2019 01:48 PM
Sorry, I didn't catch. You type some text in c1 and compare it with 10. When you'd like to have TRUE and when FALSE, for which combination of text and 10?
Jun 08 2019 01:58 PM
Jun 08 2019 02:04 PM
Jun 08 2019 02:08 PM - edited Jun 08 2019 02:24 PM
So, to return
if in C1 is text AND in D1 is FALSE then value
and
Where to take value?
If in C1 is text and in D1 is TRUE?
If in C1 is not text?
As a staring point you may use check ISTEXT(C1) and build logic based on it
Jun 08 2019 02:25 PM
Jun 08 2019 02:44 PM
Perhaps
=IF(ISNUMBER(C1)*(C1>=10),2,0)
if I understood your logic correctly. Please see in attached file.