I have a column of expenses C8:C21. The column is defined as Currency and is all negative values.

I want to create a formula that will fill in another column with the percent for each dollar amount in the expense column.

I have a name defined "inc" it contains "3435/*-1" The minus one is needed to convert the percentage to a positive value.

You want to show percent of what? Percent of the total expenses? Give us a simple example of what you're trying to do so we can help. But if that's all you need then the percentage of each expense is the value of that expense divided by the sum of all expenses.

Yes, I know that. The formula I use is "=C14/inc" inc is a defined name and contains 3435*-1. This will yield a positive percentage. The value of C14 will always be a negative number.

I have a column of "currency" values, C14:C25 that I want the formula to process automatically without having to enter the formula on each cell of an adjacent column.

N14 - - =C14/inc >> -1500/3435*-1 = 43%

Why not create a name called "pct," which equals c14/(c$14:c$25). Then the formula to use in cell N14 is simply "=pct". You can copy and paste that to all other cells C15 through C25.

I'll try that now. THANKS!

Sorry, what I should have written is pct equals c14/sum(c$14:c$25).

What you gave me does work and yield the value I need for the column. The modified formula I used is "=$C6:$C20/(3435*-1).

That gets the correct values for each column entry. I realize I could have used "/-3435" but I want to show how the sign is changed.

Now the problem is that even though I declared the name as "workbook" when I go to use it on a different worksheet it posts an incorrect value.

I edited the formula and found that it is because value that it pulls from C6 is from another worksheet. In the Name Manager dropdown, edit =pct, I found that the formula is linked to a specific worksheet, for example" ='Sept Fixed Expenses'!$C7:$C23/(3435*-1)"

If I use the same formula for the August worksheet I get the September values plugged into the August column.

Do I have to rename and then define the formula for each page I need to use it on?