Default of IF statement doesn't work when copied
 

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?

Default of IF statement doesn't work when copied
 

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?

Default of IF statement doesn't work when copied
 

Tim: Thanks for the ideas.
I've checked all the cells over and over.
I've looked at the formating of each cell, comparing the original to the
non-responsive one.
I just copied the non-responsive lines to a new, blank worksheet and the
formulas work great!!
What could I possibly have in my working sheet that would stop this
statement from working?


"tim m" wrote:

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?

Default of IF statement doesn't work when copied
 

ALSO:
I tried making up the required entries from scratch ( as oppossed to
copying), but still got the same incorrect result.

I'm totally stumped!


"tim m" wrote:

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?