Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating In Excel | Excel Discussion (Misc queries) | |||
Calculating In Excel | Excel Discussion (Misc queries) | |||
calculating age in excel | New Users to Excel | |||
In excel the sum is not calculating | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions |