Hi there, looking for a simple solution (I hope). I've attached a picture of the spreadsheet I've created.

I would like the qty in cell (2D) to change to "0" IF any data (ex: address) is entered into cell (2E).

I would need this function to work for each associate set of cells (change 5D IF data entered into 5E etc.)

If there is a simple way to do this I would greatly appreciate the help

PS - not an excel genius at all.ExcelForumEx.jpg