Groups

# Microsoft Excel Help

Im doing an assignment for accounting and ive been told to show my workings, does anyone know of an easy way for excel to do this automatically.

To clarify, i want the number value of the calculation e.g. 600*10=6000 rather than the formula.

Rep for anyone who can help.

To clarify, i want the number value of the calculation e.g. 600*10=6000 rather than the formula.

Rep for anyone who can help.

Original Poster

Maybe by "show your workings" they mean to just show the formula?

If you have used a formula, then you can either display the result of the formula, or the formula itself. The whole point of a spreadsheet model is to be able to use variables - and you want fixed values to be displayed. You can only show the fixed values if you

fixed values- i.e. type in "=60*100" and the answer will be displayed, or set the spreadsheet to show formulas and the calculation will be displayed.useOriginal Poster

Yes kind of, below is a screenshot showing how i want it to look.

img65.imageshack.us/i/f…pg/

Original Poster

this is what i thought, although i have to do about 100 manual entried and really really want there to be a an easy way to do it lol

You then copy and paste it to a second and turn on "view formulas" in the options.

You cant have them side by side.

Banned

Original Poster

but i dont want d8*e5=600 to be displayed i want 300+300=600 to be shown.

EDIT: going to rep those who have tried to help....thanks guys

Banned

I haven't got excel on my lappy at home so I can't check it out but i wonder if there's a formula you could use. There maybe something like value or result that you could use.......eg value (d3) + value (e3) =600 and that would bring back the value of those cells and therefore display 300 +300=600. Have you tried using the online help on there to see if there are any formulas that may do it?

Original Poster

thanks mate ive checked the online help but to no avail. which is why i posted here, nevermind manually it is