Search:

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

I'll try that now. THANKS!

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

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