Forum Thread

Excel formula input question

Novakingwai 2,144 263 February 2, 2016 at 07:22 AM
I have a spread sheet that we do daily. Most of the cells will have a formula to have several numbers added together. A lot of these numbers are used in several other cells. I know how to have the cells have inputs form other cells, for example D6+E5. It would be much easier to type in all the numbers used in one section, and have the spreadsheet fill it in the appropriate boxes. HOWEVER, they can't know it's being done so the formulas have to be invisible. And it has to show the numbers, instead of the formula. For example, the cell can't say D6+ E5, it has to show the numbers, like $100+ $45.50. Is this possible?

Yes I know this is unncessary work, but the people I am doing this for are old fashioned and do not like change. I have to do this in secret.

26 Comments

1 2

Sign up for a Slickdeals account to remove this ad.

#2
To have cell D8 contain the same value as cell A2 just enter =A2 in cell D8. Need that data to also show up in F10, then enter =A2 in cell F10.
Reply Helpful Comment? 0 0
Joined Jul 2013
Conservative with a gun
2,144 Posts
263 Reputation
Original Poster
#3
Quote from HarryH3 View Post :
To have cell D8 contain the same value as cell A2 just enter =A2 in cell D8. Need that data to also show up in F10, then enter =A2 in cell F10.
Sorry, wasn't finished posting. Don't believe your answer is what I'm looking for.
Reply Helpful Comment? 0 0
An armed man is a citizen. An unarmed man is a subject.
The strongest reason for the people to retain the right to keep and bear arms is, as a last resort, to protect themselves against tyranny in government.
A gun in the hand is better than a cop on the phone
#4
Quote from Novakingwai View Post :
Sorry, wasn't finished posting. Don't believe your answer is what I'm looking for.
So you're looking for a way to print out the formula with the numbers filled in?

You could use the string concatenation operator &

E.g. d1 & " + " & e1
Reply Helpful Comment? 0 0
#5
You want it to show cell values in the field when you click it? Not sure how to do that one since the cells themselves are what need to be operated on in the formula.

One suggestion I have is to "name" the fields. Select the cell or group of cells and in the top left where it shows the address you can type in a name. Doing this lets you reference the name in calculations.

Instead of saying A1+B4 you could name them to say (Money + Booze).

I will think on it more, but I don't know a way for excel to immediately show the elements inside of a function rather than the cells.
Reply Helpful Comment? 0 0
Caldari on the streets
Minmatar in the sheets
#6
a10 =a1+a2 press enter
Reply Helpful Comment? 0 0
Joined Jul 2013
Conservative with a gun
2,144 Posts
263 Reputation
Original Poster
#7
Quote from techky View Post :
a10 =a1+a2 press enter
You did not read the post or do not understand what I am asking
Reply Helpful Comment? 0 0
#8
Quote from Novakingwai View Post :
You did not read the post or do not understand what I am asking
can you please elaborate your question so i can tell you exactly , i have good experience in excel . also send me a snapshot if required
Reply Helpful Comment? 0 0

Sign up for a Slickdeals account to remove this ad.

Joined Jul 2013
Conservative with a gun
2,144 Posts
263 Reputation
Original Poster
#9
Quote from techky View Post :
can you please elaborate your question so i can tell you exactly , i have good experience in excel . also send me a snapshot if required
I do want it to work like that, but it can't be that obvious. The cell has to be invisible or show the numbers it's adding, not just the formula
Reply Helpful Comment? 0 0
#10
Quote from Novakingwai View Post :
I do want it to work like that, but it can't be that obvious. The cell has to be invisible or show the numbers it's adding, not just the formula
Go in Formula Tab and check the show formula
Reply Helpful Comment? 0 0
Joined Jul 2005
killroy was here
9,117 Posts
1,224 Reputation
#11
i'm pretty sure what you asking for isn't possible without a macro or something. if you click on a cell it'll show the cell references, that isn't something you can turn off. or only show the values.

you could name cells so the name you give the cell shows up vs the X:X reference.

seems more like whoever wants this doesn't need excel if they don't want to use formulas. unless i'm missing what you actually want.
Reply Helpful Comment? 0 0
so i spent time making a signature. only to realize that you couldn't put an image in the signature. please enjoy the link to my signature, assuming it works.

http://imgur.com/FtBghZ2
Joined Jul 2013
Conservative with a gun
2,144 Posts
263 Reputation
Original Poster
#12
Quote from dayv View Post :
i'm pretty sure what you asking for isn't possible without a macro or something. if you click on a cell it'll show the cell references, that isn't something you can turn off. or only show the values.

you could name cells so the name you give the cell shows up vs the X:X reference.

seems more like whoever wants this doesn't need excel if they don't want to use formulas. unless i'm missing what you actually want.
Yes it is very asinine. We have a report printed every day with about 20 values that are used about 50-60 times in various formulas. And instead of having the 20 values in cells, and the formulas calling on those cells, they want us to manually input them in every cell. Which is completely crazy, but they are extremely stubborn so I was trying to find a way to do it invisibly.
Reply Helpful Comment? 0 0
#13
Quote from Novakingwai View Post :
Yes it is very asinine. We have a report printed every day with about 20 values that are used about 50-60 times in various formulas. And instead of having the 20 values in cells, and the formulas calling on those cells, they want us to manually input them in every cell. Which is completely crazy, but they are extremely stubborn so I was trying to find a way to do it invisibly.
Build a macro. Name the cells to move around and use a macro to populate what you need.

This would let you run the formula in a locked/invisible area on another sheet if needed and simply copy the results to where you want people to see.

I agree that this is a ridiculous use of excel. And this is coming from someone that has used excel VB and macros as a database frontend. I thought that was awful enough.
Reply Helpful Comment? 0 0
Joined Jul 2013
Conservative with a gun
2,144 Posts
263 Reputation
Original Poster
#14
Quote from Pedantyc View Post :
Build a macro. Name the cells to move around and use a macro to populate what you need.

This would let you run the formula in a locked/invisible area on another sheet if needed and simply copy the results to where you want people to see.

I agree that this is a ridiculous use of excel. And this is coming from someone that has used excel VB and macros as a database frontend. I thought that was awful enough.
I am not familiar with Excel macros I will look into them. Have any tips?
Reply Helpful Comment? 0 0
Joined Jul 2005
killroy was here
9,117 Posts
1,224 Reputation
#15
my tip is to kill your boss and hide the body. but you asked pedantyc not me.

you should push the issue for them to allow formulas. since if you have to manually update 50 cells vs a dozen. you are at least 4x likely to make a mistake. probably more likely since it seems like a pointless task.
Reply Helpful Comment? 0 0
Page 1 of 2
1 2
Join the Conversation
Add a Comment
 
Copyright 1999 - 2016. Slickdeals, LLC. All Rights Reserved. Copyright / Infringement Policy  •  Privacy Policy  •  Terms of Service  •  Acceptable Use Policy (Rules)  •  Interest-Based Ads
Link Copied to Clipboard