I want to sum two value but result shows add with + Sign. Example
Student ID Fee Student ID Sum
1 100 1 400 (calculate sum but when goes to cell show like +100+300)
2 200 2 700 (+200+200+300)
1 300 3
3 200 4
4 100
2 200
2 300
I want to sum two value but result shows add with + Sign. Example
Student ID Fee Student ID Sum
1 100 1 400 (calculate sum but when goes to cell show like +100+300)
2 200 2 700 (+200+200+300)
1 300 3
3 200 4
4 100
2 200
2 300
I want to sum two value but result shows add with + Sign. Example
Student ID Fee Student ID Sum
1 100 1 400 (calculate sum but when goes to cell show like +100+300)
2 200 2 700 (+200+200+300)
1 300 3
3 200 4
4 100
2 200
2 300
it's not clear for me, attach a sample file with more comments
Hi
You can toggle the formula view by cliking Ctrl + `
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
In MS excel 2007, you can go to select the Home button and select Excel Options>> Go to Advanced, under "Display options for this worksheet" u can select "Show Formulas in cells instead of their calculated results. This would show you the formula instead of the value.
Do you mean you want to show the result of the sum in the cell, but the formula in the cell should not contain an equal (=) sign at the beginning?
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Attched Sample File
Posting Permissions
Reply With Quote
Bookmarks