Home |
Search |
Today's Posts |
#1
|
|||
|
|||
muliply
How do I multiply a row or column of numbers by the same number ie,
a1,a2,a3,a4 etc by .8 and have all the answers displayed on the worksheet? |
#2
|
|||
|
|||
Hi
in B1 enter =A1*0.8 and copy this formula down -- Regards Frank Kabel Frankfurt, Germany sapphria wrote: How do I multiply a row or column of numbers by the same number ie, a1,a2,a3,a4 etc by .8 and have all the answers displayed on the worksheet? |
#3
|
|||
|
|||
If it's a one-time thing, one way:
Put 0.8 in an empty cell. Copy the cell. Select your range (e.g., column or row). Choose Edit/Paste Special, selecting the Values and Multiply radio buttons. Click OK. In article , "sapphria" wrote: How do I multiply a row or column of numbers by the same number ie, a1,a2,a3,a4 etc by .8 and have all the answers displayed on the worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|