Microsoft Excel Help - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Microsoft Excel Help

£0.00 @
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 calculati…
leecher Avatar
7y, 7m agoPosted 7 years, 7 months ago
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.
leecher Avatar
7y, 7m agoPosted 7 years, 7 months ago
Options

All Comments

(12) Jump to unreadPost a comment
Comments/page:
#1
on Excel 2007, click on FORMULAS, then click SHOW FORMULAS
#2
This makes it appear as =SUM(A7:A10) as an example....i want the actual numbers to show, thanks for you reply though
#3
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?
1 Like #4
I don't think what you are asking for is possible - though I'd be happy to be proved wrong! :p

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.
1 Like #5
So you want to show the answer and formula on the same sheet?
#6
chester123
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.
http://img65.imageshack.us/i/formula.jpg/
http://img65.imageshack.us/i/formula.jpg/
#7
Jazz
I don't think what you are asking for is possible - though I'd be happy to be proved wrong! :p

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.


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
#8
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 1 Like #9
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.
#10
The Crow
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#11
leecher
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?
#12
The Crow
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

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Looking for Twitter login?
Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!