help
 

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

help
 

=E2/7

--


Regards,


Peo Sjoblom

"njenkins" wrote in message
...
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

help
 

=E2/0.7
--
John C


"Peo Sjoblom" wrote:

=E2/7

--


Regards,


Peo Sjoblom

"njenkins" wrote in message
...
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

help
 

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
--
Wag more, bark less


"njenkins" wrote:

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

help
 

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.

--
Thanks,
Shane Devenshire


"njenkins" wrote:

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