Forum Discussion
Solved
Adding a value to an cell that has no value but has a formula
Hi Team, wondering if there is a way to put a value say "1000' into a cell that is empty (no value) but has a formula in it, and ignores it if it does have a number in it...any offers of assistance ...
- Hi Hans,
Your a rock star thanks for this, i only built the AB5 etc to group the data together but your method is far better and works so thanks so much for taking the time to look at this for me its much appreciated.
I don't understand why cell AB5, under the text "QB2", refers to cell N5, under the text "QB1", etc.
But perhaps the attached version will do what you want.
Hi Hans,
Your a rock star thanks for this, i only built the AB5 etc to group the data together but your method is far better and works so thanks so much for taking the time to look at this for me its much appreciated.
Your a rock star thanks for this, i only built the AB5 etc to group the data together but your method is far better and works so thanks so much for taking the time to look at this for me its much appreciated.