Hello,
is it possible to convert a function into text with its values?
Some function like FORMULATEXT() but it should display the values instead of A1, A2 etc
I attach a picture to show what i mean
Hello,
is it possible to convert a function into text with its values?
Some function like FORMULATEXT() but it should display the values instead of A1, A2 etc
I attach a picture to show what i mean
If I understand correctly you would like B2 to display 1*2*3. If so put this formula in B2:Let me know if you have any questions.Please Login or Register to view this content.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Yes, that is correct.
But Im looking for a macro or formula which creates the expression automatically because if you have many and long formulas it will be very exhausting
for Ex2013 and above:Formula:Please Login or Register to view this content.
for less then Ex2013:usage: ShowFormula(A1)Please Login or Register to view this content.
edit:
I lost Value instead A1,A2 etc. sorry
here is:
insert in standard module
usage: =LiteralFormula(A1)Please Login or Register to view this content.
formula: =A1*A2+A3
result: 2*4+7
Last edited by sandy666; 02-27-2016 at 06:13 PM.
To multiply values use PRODUCT function
Formula:Please Login or Register to view this content.
v A B 1 1 2 2 6 3 3
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
What about writing a formula that would allow you to put values in the first 10 rows of column A and then automatically put an asterisk in column B corresponding to whether or not the cell to the left AND the cell to the left and down have values, like this:
Show the formula.xlsx
Here is the formula for B1 through B9:Here is the formula for C2 (which incorporates AlKey's answer):Please Login or Register to view this content.
Test it out by adding a number to A6 or deleting the number in A5.Please Login or Register to view this content.
Let me know if you have any questions.
A simple User Defined Function is all you need.
Please Login or Register to view this content.
Or you could use a simple function:
Formula:Please Login or Register to view this content.
Or
Formula:Please Login or Register to view this content.
Last edited by mehmetcik; 02-27-2016 at 06:31 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Glad to help
One more thing: it doesn't work with $$, like $A$1 but A1. I think it is not a big problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks