Mar 15 2022 02:55 PM
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..
Mar 15 2022 03:00 PM
Make the formula return 1000 instead of 0 or "-" (I don't know what it currently returns in the marked cells)
Mar 15 2022 03:12 PM
Mar 15 2022 03:13 PM
Sorry, I don't understand. Can you explain in more detail?
Mar 15 2022 03:54 PM
@Hans Vogelaar 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 apologies
Mar 15 2022 04:24 PM
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.
Mar 15 2022 04:28 PM
SolutionMar 15 2022 04:28 PM
Solution