Formula Help

ryan7

Board Regular
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

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Excel Formula:
``=if(or(N7>=1000,O7<0),N7,N7+O7)``

Excel Formula:
``=if(or(N7>=1000,O7<0),N7,N7+O7)``
Didn't work I'm afraid.

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?

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

It should give the value 5182. Not 8342

Does this do what you want?
Excel Formula:
``=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.

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.

Does this do what you want?
Excel Formula:
``=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.

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
NO
7500100
8500-100
92000500
102000-500
11-100100
12-100-100
Main

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
NO
7500100
8500-100
92000500
102000-500
11-100100
12-100-100
Main

600
500
500
0
100
0

Replies
3
Views
228
Replies
3
Views
208
Replies
1
Views
256
Replies
4
Views
254
Replies
1
Views
305

1,203,171
Messages
6,053,885
Members
444,692
Latest member
Queendom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back