|
|
#3
05-25-2023, 11:58 AM
|
|||
|
|||
Thank you, p45cal. This helps. The result is the correct value but I would prefer to get the individual values in a formula. EX =100+5-1 to display 104. This makes it easy to know where the values originated.
The sheets that I am working with are in two different workbooks. 
|
| Tags |
| combine data in cells, vba to display a formula. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to match one list with another and return certain values from corresponding cells in excel | Oluagbe1 | Excel | 10 | 02-11-2019 07:00 PM |
 Loop through cells and return only unique values
|
trevorc | Excel Programming | 4 | 10-11-2018 03:49 PM |
|
have a formula that combines two cells return a zero instead of a blank cell
|
Kubi | Excel | 3 | 08-07-2017 11:52 PM |
| Formula/function to return column names for matching values | GiJoe81 | Excel | 1 | 06-27-2015 12:13 AM |
|
Excel Formula: return a range of cells that match
|
tinfanide | Excel | 4 | 08-30-2014 07:03 AM |
Windows 11 
Office 2021
Threaded Mode