I just did a little test and it seemed to work as intended for me. After you
copy the formula is it as shown in your example or perhaps it is still
pointing to your test sheet? (As in referring to the data in your test sheet
rather than your price book.)

"BEEJAY" wrote:

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?