View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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