![]() |
calculating in excel
Hi
I am very new to excel so I hope someone can guide me I have a speadsheet that has 3 fields each containing a number that I want to have calculated for me this what I would like to happen the first number say 85 * 25% = ? the second number say 88 * 25% = ? the third number say 87 * 50% = ? so The number would change to 25% of 85 I hope that make sense thank sfor any help John |
calculating in excel
Not sure this is what you need put 85 in A1 25% into B1
and enter this into C1 =A1*B1 "johnc" wrote: Hi I am very new to excel so I hope someone can guide me I have a speadsheet that has 3 fields each containing a number that I want to have calculated for me this what I would like to happen the first number say 85 * 25% = ? the second number say 88 * 25% = ? the third number say 87 * 50% = ? so The number would change to 25% of 85 I hope that make sense thank sfor any help John |
calculating in excel
If your first number is in A1, then in B1 put:
=A1*0.25 If other numbers are A2 and A3 then repeat above for B2 and B3 changing A1 to A2 & A3 =A2*0.25 =A3*0.50 HTH "johnc" wrote: Hi I am very new to excel so I hope someone can guide me I have a speadsheet that has 3 fields each containing a number that I want to have calculated for me this what I would like to happen the first number say 85 * 25% = ? the second number say 88 * 25% = ? the third number say 87 * 50% = ? so The number would change to 25% of 85 I hope that make sense thank sfor any help John |
All times are GMT +1. The time now is 07:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com