| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#name error
c10 = 40; d10 can be any number above or below 40. The formula I am using is
supposed to either read the number above or below 40 and read either # over or # under, depending on which it is. For example, if c10=40 and d10=39.25 then e10 should read .75 under. If c10 and d10 are both forty then it would read "at projection". Here is the formula: =IF(OR(D11,C11),IF(D11-C110,STRING(D11-C11,2)&"over",IF(D11-C11<0,STRING(C11-D11,2)&"under","at projection"))," ") However, if I put any number other than 40 in d10 I just get a #name error displayed in the corresponding cell (e10) Anybody have any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| ERROR | Excel Discussion (Misc queries) | |||
Threaded Mode
