# Formula question???

#### Boler

##### New Member
180000 144000 108000 72000 A1
36000 36000 36000 36000 A2
36000 72000 108000 144000 180000
-8.45 -6290 -130 2030

What I am trying to do is the following:
A1 - If cell 2030 is positive I would like it to add up with Cell 72000 and Cell 36000, if the total goes above cell 180000 I would like cell 2030 to subtract itself from cell 36000.

I hope I didn't make this to confusing. Any help would be great.

Thank you!

### 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)

##### MrExcel MVP
what on earth does "cell 720000" refer to?

#### Boler

##### New Member
I have put a number in the cell showing that it contains a number. The cells with A1 and A2 are blank and I am looking for the formula to put those cells that is why they are "Blank".

#### plettieri

##### Well-known Member
Hi:

It might a bit helpful if you would show your data in the Colo utility...then we could see exactly your references...as well as you anticipated results...

plettieri

#### Boler

##### New Member
What is Colo Utility?

#### plettieri

##### Well-known Member
As posted in a PM to OP on 1/22/04

Hi:

The utility I refer to is the HTML approach to displaying a portion of your spreadsheet on the forum....See just below this text box the following:

and follow the install instructions....You can also find help on the search section of this forum....search for "Colo utility"

hope this helps

plettieri

Replies
3
Views
208
Replies
17
Views
223
Replies
4
Views
159
Replies
5
Views
166
Replies
0
Views
220

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,152,159
Messages
5,768,523
Members
425,479
Latest member
Neerajcool

### 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.

### Which adblocker are you using?

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