ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   calculating in excel (https://www.excelbanter.com/excel-discussion-misc-queries/140549-calculating-excel.html)

JohnC

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

Mike

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


Toppers

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