A seperate workbook is used when designing any additions for our price book.
Upon completion, the additional item is copied, then Inserted into each
price book.
This has always worked great, till now.
The following formula works great on my "design" sheet.
After inserting into the price books, if there is NO selection (or selection
deleted)
in cell D336, cell E336 still returns a "1", NOT the expected "0".

=IF(D336="Front",1,IF(D336="Rear",1,IF(D336="Both" ,2,0)))

What is happening? How to fix?