Forum Discussion
Adding a value to an cell that has no value but has a formula
- 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.
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?
HansVogelaar Hi Hans,
i have used a choose(match function looking at four columns, and it picks the values in the quantity breaks and should return the break $ value when the qty is added however we have to few values the $ value does not show or is incorrect until i add more values to overcome this issue i have attached the sheet for reference for you to see what i am doing as i find it difficult to explain it in more detail sorry....so best to see for your self....highlighted cells for reference and some notes to explain via text box, sorry i am bit new to xcel so apologiesI 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.