N
njenkins
in row e i have a number in row f i want it to equal the number in row e
divived by .7 how can this be done
divived by .7 how can this be done
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
=E2/7
--
Regards,
Peo Sjoblom
--
Regards,
Peo Sjoblom
J
John C
B
Brad
Peo didn't see the decimal point - assuming that the number is in e2 in a
cell in row f enter this formula....
=e2/.7
cell in row f enter this formula....
=e2/.7
S
ShaneDevenshire
Hi,
One of the most powerful features in Excel is its dynamic nature, so it is
often best to enter the values you want to work with in cells and then do the
calculations in other cells. In your example, them means then you should
enter the value .7 in another cell, say A1 and then instead of =E1/.7 you
would write =E1/A1. If you want to be able to copy this formula so that it
uses the value in A1 on all rows of column F, modify the formula to read:
=E1/A$1 or =E1/$A$1.
The dollar signs mean make the reference following them absolute, don't
allow it to change when copying.
One of the most powerful features in Excel is its dynamic nature, so it is
often best to enter the values you want to work with in cells and then do the
calculations in other cells. In your example, them means then you should
enter the value .7 in another cell, say A1 and then instead of =E1/.7 you
would write =E1/A1. If you want to be able to copy this formula so that it
uses the value in A1 on all rows of column F, modify the formula to read:
=E1/A$1 or =E1/$A$1.
The dollar signs mean make the reference following them absolute, don't
allow it to change when copying.