Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how make a formula for 2 different numbers
How do i put in the formula if I want to know the value of two numbers.
example; 60% of 315 is what? How do I put that in excel |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how make a formula for 2 different numbers
=60%*315
-- Regards, Peo Sjoblom "jake30" wrote in message ... How do i put in the formula if I want to know the value of two numbers. example; 60% of 315 is what? How do I put that in excel |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how make a formula for 2 different numbers
Suppose you have entered in A1: 60% (the "%" is entered as well), in B1: 315,
then you could place in C1: =A1*B1 to compute the result. And if A2:B2, A3:B3 contains other pairs of percentages and numbers to be multiplied, you could simply copy the formula in C1 down by dragging the fill handle at the bottom right corner of C1 (the solid black square). -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "jake30" wrote: How do i put in the formula if I want to know the value of two numbers. example; 60% of 315 is what? How do I put that in excel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make negative numbers to become 0? | Excel Worksheet Functions | |||
how do i make negative numbers equal zero | Excel Worksheet Functions | |||
How to make numbers change color ? | Excel Discussion (Misc queries) | |||
How to make negative numbers look like 0 | Excel Discussion (Misc queries) | |||
how i can make the numbers | Excel Discussion (Misc queries) |