Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-31-2017, 09:30 AM
JoyLearner JoyLearner is offline Convert cell with formula to literal value Windows 7 64bit Convert cell with formula to literal value Office 2016
Novice
Convert cell with formula to literal value
 
Join Date: May 2017
Posts: 3
JoyLearner is on a distinguished road
Default


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.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert cell with formula to literal value 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 cell with formula to literal value convert text cell to numeric cell mikec Excel Programming 2 08-19-2015 02:51 PM
Convert cell with formula to literal value 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft