Calculations within Project

J

jacci007

I have to type in the calculations with in Parenthesis in this project that
looks like the following

e. The volunteer's tax knowledge
Excellent 80% 77% (-3) 76% (-4) 75% (-5)
Good 17% 18% (+1) 19% (+2) 20% (+3)
Fair 1% 2% (+1) 1% 2% (+1)
Poor --% 1% ** **
No Answer 2% 2% 4% (+2) 4% (+2)

Is there a formlua that I can use to generate the information in parenthesis
and how would I have it represented in () format?
 
M

Michael

Assuming you have the number 80% on B1 do this
=(B1-D1)*100 where you see the (3)
Cells format equals general
Copy and paste to other cells
 
Top