ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formula doesn't work (https://www.excelbanter.com/excel-discussion-misc-queries/38332-formula-doesnt-work.html)

JJ

formula doesn't work
 
Hi,

I am using window XP, have column B, C and D. Cell C1 and B1 are the numbers.
I try to enter a formula into column D, it keeps give me C1/B1*100 in cell
D1. Why it won't give me the numbers in D1? Is this my Exel's setting problem?
--
JJ

Harald Staff

Hi JJ

Instead of
C1/B1*100
try
=C1/B1*100

HTH. Best wishes Harald

"JJ" skrev i melding
...
Hi,

I am using window XP, have column B, C and D. Cell C1 and B1 are the

numbers.
I try to enter a formula into column D, it keeps give me C1/B1*100 in

cell
D1. Why it won't give me the numbers in D1? Is this my Exel's setting

problem?
--
JJ




JJ

i tryed =c1/d1*100 also, still doesn't work. then when I try to do this in
another station, it works. I am thinking maybe the setting is different?

thanks
--
JJ


"Harald Staff" wrote:

Hi JJ

Instead of
C1/B1*100
try
=C1/B1*100

HTH. Best wishes Harald

"JJ" skrev i melding
...
Hi,

I am using window XP, have column B, C and D. Cell C1 and B1 are the

numbers.
I try to enter a formula into column D, it keeps give me C1/B1*100 in

cell
D1. Why it won't give me the numbers in D1? Is this my Exel's setting

problem?
--
JJ





Harald Staff

Is "formulas" checked in the Tools Options menu, "view" pane ? Uncheck it
if so. Anyway, all formulas start with = .

HTH. Best wishes Harald

"JJ" skrev i melding
...
i tryed =c1/d1*100 also, still doesn't work. then when I try to do this in
another station, it works. I am thinking maybe the setting is different?

thanks
--
JJ


"Harald Staff" wrote:

Hi JJ

Instead of
C1/B1*100
try
=C1/B1*100

HTH. Best wishes Harald

"JJ" skrev i melding
...
Hi,

I am using window XP, have column B, C and D. Cell C1 and B1 are the

numbers.
I try to enter a formula into column D, it keeps give me C1/B1*100 in

cell
D1. Why it won't give me the numbers in D1? Is this my Exel's setting

problem?
--
JJ







JJ

THANK YOU
--
JJ


"JJ" wrote:

Hi,

I am using window XP, have column B, C and D. Cell C1 and B1 are the numbers.
I try to enter a formula into column D, it keeps give me C1/B1*100 in cell
D1. Why it won't give me the numbers in D1? Is this my Exel's setting problem?
--
JJ



All times are GMT +1. The time now is 02:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com