Hi Ron
Just to make this more difficult. i am using =IF($B3="",0,Max,(1,C$2*$B3))
which is working but now have extra hassle. It is returning a minimum of 1
except if cell B3 is empty which is great. however, I have a problem as
occassionally cell C2 is Zero. This means no guests are travelling so I DO
NEED a zero value and not a minimum of 1 otherwise they are buying
ingredients for non existent guests. Any way I can change it to include
this issue as well? thanks.
Shane, see you have posted but i cannot see it for some reason. happens to
me often.