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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use IF to substitute for another cell?
Without seeing the formula all I can do is show an example of trapping for
errors. =IF(ISERROR(A1+B1),C3,A1+B1) In 2007 version use =IFERROR(A1+B1,C3) ISERROR wil trap all errors so may not be desirable. Maybe trap for a cell or cells being blank. I don't know why you would get a #REF! just from missing data but again, I can't see your formula. Gord Dibben MS Excel MVP On Sat, 24 Oct 2009 06:48:01 -0700, Tim wrote: 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. |
Reply |
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 |