Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I check a formula?
Is there a program or a website where I can insert my formula and have it
checked. Is there an add-on of some sort? I use Excel2000. |
#2
|
|||
|
|||
checked for what?
-- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "jnord" wrote in message ... Is there a program or a website where I can insert my formula and have it checked. Is there an add-on of some sort? I use Excel2000. |
#3
|
|||
|
|||
jnord,
Post it here. You'll have dozens of reviewers.... And sign your post with a name. HTH, Bernie MS Excel MVP "jnord" wrote in message ... Is there a program or a website where I can insert my formula and have it checked. Is there an add-on of some sort? I use Excel2000. |
#4
|
|||
|
|||
The president of the company wants something to check his formulas with. I
think he wants to past it in somewhere and have it checked for accuracy. I am not sure if there is such an animal as every formula serves its own purpose. Is there any way to determine if the formula is giving the correct answer? "Bernie Deitrick" wrote: jnord, Post it here. You'll have dozens of reviewers.... And sign your post with a name. HTH, Bernie MS Excel MVP "jnord" wrote in message ... Is there a program or a website where I can insert my formula and have it checked. Is there an add-on of some sort? I use Excel2000. |
#5
|
|||
|
|||
Checked to ensure that it works exactly as he
-- HTH RP (remove nothere from the email address if mailing direct) "JulieD" wrote in message ... checked for what? -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ...well i'm working on it anyway "jnord" wrote in message ... Is there a program or a website where I can insert my formula and have it checked. Is there an add-on of some sort? I use Excel2000. |
#6
|
|||
|
|||
Try again<g
Checked to ensure that it works exactly as he intended, irrespective of what he actually puts in the formula, and takes care of any changes that he hasn't thought of yet. I would have thought was obvious Julie <vbg Bob "JulieD" wrote in message ... checked for what? -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ...well i'm working on it anyway "jnord" wrote in message ... Is there a program or a website where I can insert my formula and have it checked. Is there an add-on of some sort? I use Excel2000. |
#7
|
|||
|
|||
This won't work for printing, but xl2002 (IIRC), added:
Tools|Formula auditing|evaluate formula You can step through the formula to see how each portion evaluates. If you're not running xl2002+, you can select a portion of the formula in the formula bar and hit F9 to evaluate it. (Hitting Escape will revert the formula to its original form.) And ctrl-z will revert the portion you just calculated. And if you hit enter by mistake Edit|Undo (or ctrl-z) will get it back to where it was. Jay wrote: The president of the company wants something to check his formulas with. I think he wants to past it in somewhere and have it checked for accuracy. I am not sure if there is such an animal as every formula serves its own purpose. Is there any way to determine if the formula is giving the correct answer? "Bernie Deitrick" wrote: jnord, Post it here. You'll have dozens of reviewers.... And sign your post with a name. HTH, Bernie MS Excel MVP "jnord" wrote in message ... Is there a program or a website where I can insert my formula and have it checked. Is there an add-on of some sort? I use Excel2000. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions | |||
ANY FORMULA FOR CHECK =ISBOLD(A1) | Excel Worksheet Functions |