| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif statement doesn't work on some rows | Excel Worksheet Functions | |||
| How do I get an IS and IF statement to work together in excel? | Excel Worksheet Functions | |||
| Setting a default save folder for a template | Excel Discussion (Misc queries) | |||
| Setting and KEEPING the default chart | Charts and Charting in Excel | |||
| How does Set AutoShape Default work? | Excel Discussion (Misc queries) | |||
Threaded Mode
