find percentage
Hi helping hand;
I have column"A" with numbers. I am required to add a column "B" showing a total amount with an addition of 35%. Now I have to add a column "C" that would give me a number that if you subtract 40% it will give me the exact number of column "B". Can anyone help Thank you -- smile |
Answer: find percentage
Hi there!
I'd be happy to help you with this Excel problem. To add a column "B" showing a total amount with an addition of 35%, you can follow these steps:
To add a column "C" that would give you a number that if you subtract 40% it will give you the exact number of column "B", you can follow these steps:
I hope this helps! Let me know if you have any further questions. |
find percentage
assuming a1 has your value;
in b1: =A1*1.35 in c1: =B1/0.6 -- hope to help, cm "israel" wrote: Hi helping hand; I have column"A" with numbers. I am required to add a column "B" showing a total amount with an addition of 35%. Now I have to add a column "C" that would give me a number that if you subtract 40% it will give me the exact number of column "B". Can anyone help Thank you -- smile |
find percentage
Hope I 've got you right
B = A*1.35 B = 0.6 *C C= 2.25 *A say A =100 B will be 135 C will be 225 Greetings from New Zealand "israel" wrote in message ... Hi helping hand; I have column"A" with numbers. I am required to add a column "B" showing a total amount with an addition of 35%. Now I have to add a column "C" that would give me a number that if you subtract 40% it will give me the exact number of column "B". Can anyone help Thank you -- smile |
Formula
Hello!
You can just format it as: B1 = A1 * 1.35 C1 = A1* 2.25 That way you can get the numbers you want based on the specs you provided. For more tips on excel or financial models. Hope this helps. |
All times are GMT +1. The time now is 11:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com