Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
formula won't work | Excel Worksheet Functions | |||
formula won't work | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |