| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use IF to substitute for another cell?
Hi,
i have a stock sheet, and the cost price comes from a cell which is a average. in some months though we do not have all the products delivered, so the average is either #value or #ref. In another cell though I always have what we last paid for the product, what would be the formula so that if one cell does bring up either #VALUE or #REF then i could put in the start cell? Much thanks if you can help, I am sure it is very simple. -- Tim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE.... max. limit 8 :( | Excel Discussion (Misc queries) | |||
| Using SUBSTITUTE multiple times on single cell of data | Excel Discussion (Misc queries) | |||
| substitute the filename in a cell reference with a string in another cell. | Excel Discussion (Misc queries) | |||
| =countif (h3:h16"=01 01 2006") how to substitute cell for date | Excel Worksheet Functions | |||
| Substitute ,replace and delete in a cell. | Excel Worksheet Functions | |||
Threaded Mode
