| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A formula referencing another
Morning (depending where you are...:)
Using the following to zero figures when it's a Monday: =IF(B18="Mon",D18,IF(D18<"",E17+D18,"")) where B18 is this: =IF(C18="","",WEEKDAY(C18)+1) and formatted "ddd" It doesn't work (I think) because it doesn't actually state "Mon" in the cell. If I manually type "Mon" in, it works fine. Is there a work around for this type of issue? Thanks in advance -- Traa Dy Liooar Jock |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing a control within formula | Excel Worksheet Functions | |||
| Referencing a formula | Excel Discussion (Misc queries) | |||
| Referencing a formula (as text) | Excel Worksheet Functions | |||
| Referencing Sheets in a Formula | Excel Discussion (Misc queries) | |||
| formula referencing another workbook | Excel Worksheet Functions | |||
Threaded Mode
