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]

Hi & welcome to MrExcel.
Unfortunately I don't understand what you are asking, negative numbers are always less than a positive number.

 

[daniele_t]

correct. how do i make the distinction between a negative value and the same value but positive?
sorry if i wasnot clear from the beginning

 

[Fluff]

Do you mean you want to find the larger number regardless of positive or negative?

 

[daniele_t]

actually not. trying to find if one number is larger if it is positive even if it's value is lower

 

[daniele_t]

actually not. trying to find if one number is larger if it is positive even if it's value is lower

positive 25 is greater than negative 35

 

[Fluff]

Sorry, but I still don't understand what you are asking for.
Can you post some sample data along with expected results.

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.

 

[daniele_t]

can't load anything on these pc's i work for the judicial courts and we are not allowed to access anything else than what's supplied no add ins unfortunately.

let me see if i can be clearer.

the file is large over 11k entries so need to automate the process

i have one row whose value is to be compared to another row.

row X is always positive numbers (positive numbers are credit limits)
row Y can be both positive and negative numbers (row Y is bank balance)

the simple IF function works if both values are positive.

if row Y is larger than row X then YES
if row Y is smaller than row X then NO

i run into a problem the moment that row Y is a negative number with a value that is larger than what is in
the corresponding row X

example:
row X value 80 row Y value 30 result is NO
row X value 100 row Y value 110 result is NO

problem arises when

row X is 25 and row Y is negative 35 and the result is NO

but I need it to say YES because in "monetary value" -35 is not larger than positive 25

how do I introduce the concept of negative?

How that this is enough information for you to be able to understand the issue I'm having

 

[Fluff]

Sorry, but I'm still not getting it.
What results would you expect from this

Fluff.xlsm
	A	B	C
1
2	20	40	No
3	50	40	Yes
4	-10	35	No
Data

Cell Formulas
Range	Formula
C2:C4	C2	=IF(A2>B2,"Yes","No")

 

[daniele_t]

Sorry, but I'm still not getting it.
What results would you expect from this

Fluff.xlsm
	A	B	C
1
2	20	40	No
3	50	40	Yes
4	-10	35	No
Data

Cell Formulas
Range	Formula
C2:C4	C2	=IF(A2>B2,"Yes","No")

try putting 25 in A4 and -35 in B4, and you'll see why I'm stuck