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.

on Excel 2007, click on FORMULAS, then click SHOW FORMULAS

Original Poster

This makes it appear as =SUM(A7:A10) as an example....i want the actual numbers to show, thanks for you reply though

I don't see how you can show the numbers if you have used a formula, the whole point of a formula is so that it takes into account changing numbers in the cells.

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

I don't think what you are asking for is possible - though I'd be happy to be proved wrong!

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 use 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.

So you want to show the answer and formula on the same sheet?

Original Poster

chester123;5890032

So you want to show the answer and formula on the same sheet?

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

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

Original Poster

Jazz;5890002

I don't think what you are asking for is possible - though I'd be happy … I don't think what you are asking for is possible - though I'd be happy to be proved wrong! :pIf 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 use 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.

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

I think the only way would be to do it as two sheets, on the first you have it with all your numbers.

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

you can get whatever you want to display in a cell just by typing an apostrophe in the cell in front of it. So you could do all the formulas showing the results etc and then have a workings column that you manually type in eg 'd8*e5=600. Obviously doing it this way it won't calculate the answer you will need to enter that yourself.

Original Poster

The Crow;5890190

you can get whatever you want to display in a cell just by typing an … you can get whatever you want to display in a cell just by typing an apostrophe in the cell in front of it. So you could do all the formulas showing the results etc and then have a workings column that you manually type in eg 'd8*e5=600. Obviously doing it this way it won't calculate the answer you will need to enter that yourself.

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

leecher;5890272

but i dont want d8*e5=600 to be displayed i want 300+300=600 to be … 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

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

The Crow;5890361

I haven't got excel on my lappy at home so I can't check it out but i … 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?

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