L
lecoughlin
Hi all,
I have a list of items & values in two columns.... for example
Apple 3
Banana 0
Pear 5
Orange 8
Grapefruit 0
At the bottom of the list, I want to have a cell that will say which
values are zero. For example:
"You have no bananas, grapefruit"
If apple was also = 0 it would say "You have no apples, bananas,
grapefruit"
Is there a way to do this without VBA code? Is it just going to be a
crazy IF statement?
I have a list of items & values in two columns.... for example
Apple 3
Banana 0
Pear 5
Orange 8
Grapefruit 0
At the bottom of the list, I want to have a cell that will say which
values are zero. For example:
"You have no bananas, grapefruit"
If apple was also = 0 it would say "You have no apples, bananas,
grapefruit"
Is there a way to do this without VBA code? Is it just going to be a
crazy IF statement?