| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Based on Values in Named Range Q
I have the following formula that produces a Date / Time value
BF1+(540/1440) eg 02/01/2012 09:00 What I wish to do is modify above that if BF1 equals any dates listed in a named range "Holidays" then the formula would change to BF1+1+(540/1440) Its the bit on looking up values in the named range that I can't work out |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum of a named range with values based on vlookup results | Excel Worksheet Functions | |||
| Sum values in columns based on values in named range | Excel Worksheet Functions | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
Threaded Mode
