# How to use percent in calculated column over another calculated column

I want to create a calculated column which will calculate percentage over another calculated column. E.g.:

I have three columns: ColA, ColB (=ColA-12%), ColC(=ColB-10%).

The problem is, that ColC is not calculated as I wish. I suppose, that it is because it uses another calculated colum.

In the real environment the formulas are more complicated over more columns.

Is there any option how to hack this?

thanks.

• Why don't you replace ColB in ColC formula wiht ColB formula like `ColC(=(ColA-12%)-10%)` – Arsalan Adam Khatri Jan 26 '13 at 15:16
• I can do this that's true. But I'm trying to find out if there is exists another way. In our case ColB is used in another calculated columns and ColB formula can be changed in time. It means, that i will need to change it in all another columns. – zosim Jan 26 '13 at 15:23

## 1 Answer

Why don't you replace ColB in ColC formula wiht ColB formula like `ColC(=(ColA-12%)-10%)`

Also, if you need help in calculating percentages.. The Calculate Columns actually use Microsoft Excel based formula's so you can take help from here:
How to do percentages in Excel