|
Manipulating text of an equation
Excel Experts,
I have a number of equations which I have to edit each day. I receive a MTD commission figure each day which I enter in one cell, B4. I compute the Daily commission figure in cell A4 using the formula =today's MTD commission-yesterday's MTD commission For the edit, I delete the text "-yesterday's MTD commission", then go to after the equal sign and type in the new MTD commission, then put a minus before yesterday's MTD commission. Below is how it works on the spreadsheet: Day 0 MTD Commission = 5000 Day 1 A B 1 2 Daily MTD 3 Commission Commission 4 =5200-5000 5200 5 DAY 2, MTD Commission = 5600 A B 1 2 Daily MTD 3 Commission Commission 4 =5600-5200 5600 5 My question is, once I have entered the "5600" into cell B4, what code will do the editing in cell A4 to change it from "=5200-5000" to "=5600-5200"? Thanks, Alan -- achidsey |
Manipulating text of an equation
Perhaps I'm being too simple here, but could you not use
='Day 2 MTD Commission'!B4 - 'Day 1 MTD Commission'!B4 You'll need to later the bit in ' ' to the actual sheet names being used, but it should work. Perhaps I don't understand? HTH. "achidsey" wrote: Excel Experts, I have a number of equations which I have to edit each day. I receive a MTD commission figure each day which I enter in one cell, B4. I compute the Daily commission figure in cell A4 using the formula =today's MTD commission-yesterday's MTD commission For the edit, I delete the text "-yesterday's MTD commission", then go to after the equal sign and type in the new MTD commission, then put a minus before yesterday's MTD commission. Below is how it works on the spreadsheet: Day 0 MTD Commission = 5000 Day 1 A B 1 2 Daily MTD 3 Commission Commission 4 =5200-5000 5200 5 DAY 2, MTD Commission = 5600 A B 1 2 Daily MTD 3 Commission Commission 4 =5600-5200 5600 5 My question is, once I have entered the "5600" into cell B4, what code will do the editing in cell A4 to change it from "=5200-5000" to "=5600-5200"? Thanks, Alan -- achidsey |
| All times are GMT +1. The time now is 09:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com