Thread: Formula Based on Values in Named Range Q
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Seanie Seanie is offline
external usenet poster
  
Posts: 202
Default 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
Reply With QuoteReply With Quote