Firstly, thank you and apologies for the banality of the question. I am not experienced at all with formulas. Looked through the posts but cannot find appropriate solution.
I am trying to create an IF formula to compare > (greater than) values that include negative values in statement of accounts
For example is 30 is greater than 20 then YES
and if 30 not greater than 40 then NO
so far so good, I have gotten this far.
I encounter a problem the moment I test if -20 (negative twenty) is greater than 10
which it is not.
In my example -36000 is lower than 26000
How do I include the notion that negative numbers can be lower than a positive number, even if greater.
Apologies if this has been already discussed, please point me to the correct thread.
I am trying to create an IF formula to compare > (greater than) values that include negative values in statement of accounts
For example is 30 is greater than 20 then YES
and if 30 not greater than 40 then NO
so far so good, I have gotten this far.
I encounter a problem the moment I test if -20 (negative twenty) is greater than 10
which it is not.
In my example -36000 is lower than 26000
How do I include the notion that negative numbers can be lower than a positive number, even if greater.
Apologies if this has been already discussed, please point me to the correct thread.