Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-10-2014, 02:45 AM
Steve_D Steve_D is offline Show result of formula as a value in another cell Mac OS X Show result of formula as a value in another cell Microsoft Office 2004 for Mac
Advanced Beginner
Show result of formula as a value in another cell
 
Join Date: Dec 2009
Posts: 59
Steve_D is on a distinguished road
Default Show result of formula as a value in another cell

Hi
I have a formula that returns a value (number) in cell G5. I would like that value to appear as just the value in another cell (D8), so it can be used by another (index match) formula.
If I just put =G5 in cell D8, I don't think the second formula will work, as it will be looking to match "=G5" rather than the number itself.


Is there a solution?
Thanks
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel formula from looking the base date and convert into desire result PRADEEPB270 Excel 1 02-17-2013 03:11 AM
Convert Formula Result to Static Text MYGS Excel 16 01-21-2013 08:18 AM
Show result of formula as a value in another cell If formula result is negative then display text oxicottin Excel 3 12-03-2012 02:12 AM
IF formula returns wrong result mashley Excel 3 09-07-2012 07:03 AM
Can I create a formula that will show result in the same cell and let me copy it down CranstC Excel 1 02-11-2012 01:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:04 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