|
|
#1
09-10-2014, 02:45 AM
|
|||
|
|||
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 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
 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 |
Mac OS X 
Microsoft Office 2004 for Mac
Threaded Mode