#1
|
|||
|
|||
Convert cell with formula to literal value
Cell B64 formula: =TEXT(TEXT(INT(SUM(B8:B59)/123*100),"0%")/100,"0%")
Cell B64 results: 68% My project uses a webhook that needs to grab 68% as a literal text value. What can I do to get the results of B64 into cell A64 that contains the literal value of 68%, with the value in A64 changing when the value of B64 changes? I'd even be happy with the literal value of 68 without the percent sign, if that is easier. Thanks! |
#2
|
|||
|
|||
just try =B64 in cell A64
|
#3
|
|||
|
|||
Thanks for your reply. Any formula I place in the cell will be read as a formula (literal value) by the webhook, rather than the actual value. In this case the webhook will grab "=B64" rather than 68%.
|
#4
|
||||
|
||||
What is a webhook please?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
Create a MS query which reads data from your table, and stores result on another sheet.
For MS query from excel: a) You create a nondynamic named range (the one which refers to range like Sheet1!$A$1:$Z$1000), which includes your table with header row. When the number of rows may change in future, be sure that defined range has enough empty rows at bottom. Ater that, save the workbook and then create a query. As driver select one for MS Excel files, as datasource, select your workbook, and then the named range you created. b) You create MS query as above, but without defining named range. After selecting your workbook, switch to System Tables tab (or something like that - I haven't Office at home currently so I have to count on my memory here), and select the worksheet with your table. Btw., the MS query from excel files is somewhat buggy. Often it gives a message, that some parameters are missing - especially after you edit it. Sometimes the query will work after you close the query designer window, sometimes not. When not, then try with new one. |
#6
|
|||
|
|||
Thanks, ArviLaanemets, for the suggestion. My process is automated, and from reading your suggestion it looks like it is a manual solution. Sorry if I'm misreading it.
Pecoflyer, a webhook is an application that moves data from one app to another. After more tinkering with my project, I was able to get the webhook to recognize the value of my original formula "=TEXT(TEXT(INT(SUM(B8:B59)/123*100),"0%")/100,"0%")" I think it was a matter of lining up the cell with the other app components in Zapier. So no Excel solution needed for this question. Thanks, again, for all of the suggestions. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Entering a column value in a cell, to be used as part of a reference in a formula in another cell | paulkaye | Excel | 4 | 02-26-2017 04:18 AM |
convert text cell to numeric cell | mikec | Excel Programming | 2 | 08-19-2015 02:51 PM |
Convert non-cell input to cell values | TBD | Excel | 3 | 06-09-2014 06:14 AM |
Convert Formula Result to Static Text | MYGS | Excel | 16 | 01-21-2013 08:18 AM |
Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |