Serious help

[Juanseefour]

Is is possible to find the formulas used to get a result? Pretty much I hardcoded an answer in a test and as a result of not leaving in the formula I dropped serious marks. If anyone can help it would be seriously appreciated. Thanks in advance.

 

[BadgerRoad]

Is is possible to find the formulas used to get a result? Pretty much I hardcoded an answer in a test and as a result of not leaving in the formula I dropped serious marks. If anyone can help it would be seriously appreciated. Thanks in advance.

What kind of formula? Without more details it's impossible to tell.

 

[Juanseefour]

What kind of formula? Without more details it's impossible to tell.

Sorry for not clarifying they were just Simple Vlookups.

 

[FDibbins]

You could set the display to show formulas
Click the Formulas Tab/Formula Auditing/Show Formulas
or use CTRL ` (the key to the left of the 1 key)

 

[Fluff]

Hi & welcome to the board.
Do you still have the formulas in your sheet, or have you overwritten them with the answer?
If they're still there then FDibbins answer should help.
Otherwise you'll have to create them from scratch

 

[Juanseefour]

Cheers for the help folks. I just thought there would be something built into excel that would let me show those marking it how i got the answers, as they wanted to see the formulas. Due to the reports i issue out i hardcode them. I pretty much failed for that reason. Now trying to think of whether or not there is a built in mechanism within excel where the value copied and pasted from the formula will now show the formula. If that makes any sense. either way i failed out of using "my best practice", so so soooooooooooo annoying as its the simplest part of the process and i should have passed easily. SIGH

 

[FDibbins]

...Now trying to think of whether or not there is a built in mechanism within excel where the value copied and pasted from the formula will now show the formula....

No there is not.
If the formula sill existed, you could use Trace Precedents or Trace Dependents. Find then on the Formula Tab

 

[Juanseefour]

It's all good. Well not really,but I guess I have learnt something from it all. Life isn't fair and excel need to add this feature in!

 

[FDibbins]

probably the main thing to learn from this is to make back-ups before you start making changes

 

[PaddyD]

...and that if how you got the answer is as important as the answer itself, separate the calculation of the results from their final presentation.