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 would be greatly appreciated..
- 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.
6 Replies
Make the formula return 1000 instead of 0 or "-" (I don't know what it currently returns in the marked cells)
- Hi Hans,
The formula is looking at another cell and if that cell returns no value then i would like to add the "1000" into that cell, hope that makes sense....Sorry, I don't understand. Can you explain in more detail?
