IF FUNCTION IN COMPARING STATEMENT OF ACCOUNTS

[daniele_t]

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.

 

[Fluff]

That does not answer my question. If I make that change the formula will return Yes, which is correct.

 

[daniele_t]

if i try it i get a No
i guess i dont know how to make XLS understand that -35 is a negative number

 

[Fluff]

Can you post some sample data, as Excel does recognise negative numbers are less than positive ones.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Fluff]

Please do not mark a posts as the solution when it doesn't contain one.
Have you resolved your problem?

 

[Joe4]

It sounds to me like possibly you may have numeric entries that are actually entered as text.
So Excel may be seeing them as Text and not Numbers.

Even if you cannot upload data using the XL2BB tool (which would preferrable), can you at least post an image that shows us an example of what you are talking about (show us an example that is not working as you expect)?