Formula Help

[ryan7]

Needing help with an IF Formula.

=if(N7<1000,N7+O7,O7)

What i want though is if either of the columns has a positive value then it should supersede any negative.

eg:
N7 = 75
O7 = -200
I want the answer to be 75, not -175

Thanks

 

[Fluff]

How about

=if(or(N7>=1000,O7<0),N7,N7+O7)

 

[ryan7]

How about

=if(or(N7>=1000,O7<0),N7,N7+O7)

Didn't work I'm afraid.

 

[Joe4]

Didn't work I'm afraid.

How exactly does it not work?
Fluff's formula correctly returned 75 for me.
What did it return for you?

Are you sure your entries in N7 and O7 are numeric and not text?

 

[ryan7]

Because when I paste it in
N7 = 8342
O7 = 5182

It should give the value 5182. Not 8342

 

[Joe4]

Does this do what you want?

=IF(N7<1000,N7+MAX(O7,0),O7)

If that does not work in all cases, please provide with a listing of ALL the rules/conditions that we need to consider.

 

[Fluff]

It should give the value 5182. Not 8342

But that is not what your original formula was doing. You edited it whilst I was posting a solution & you never mentioned that.

 

[ryan7]

Does this do what you want?

=IF(N7<1000,N7+MAX(O7,0),O7)

If that does not work in all cases, please provide with a listing of ALL the rules/conditions that we need to consider.

In this scenario, N3448 = 13,118, N3448 = -207
The result was -207 when I required the outcome to be zero
If the figures were in alternate cells the outcome should be 13,118.
The result was -207 when I required the outcome to be zero.

 

[Fluff]

The result was -207 when I required the outcome to be zero

You never made any mention of that before, so how were we meant to know?

What answers would do you want for the following ?

+Fluff 1.xlsm
	N	O
7	500	100
8	500	-100
9	2000	500
10	2000	-500
11	-100	100
12	-100	-100
Main

 

[ryan7]

You never made any mention of that before, so how were we meant to know?

What answers would do you want for the following ?

+Fluff 1.xlsm
	N	O
7	500	100
8	500	-100
9	2000	500
10	2000	-500
11	-100	100
12	-100	-100
Main

600
500
500
0
100
0