Value from List Box?
 

Hello,
I am revamping a timesheet in Excel and was wondering how to make all values
in a list box equal 8.
For example,
I have a drop down box for Holiday, Sick, Personal and when a user selects
one of these types 8 hours will appear in a total hours box.
Any help would be great!
Thx
-B

Value from List Box?
 

=IF(OR(A1={"Holiday","Sick","Personal"}),8,"")


"Outlook, eh?" wrote:

Hello,
I am revamping a timesheet in Excel and was wondering how to make all values
in a list box equal 8.
For example,
I have a drop down box for Holiday, Sick, Personal and when a user selects
one of these types 8 hours will appear in a total hours box.
Any help would be great!
Thx
-B

Value from List Box?
 

Great formula! I am sure I posted this before but I was just wanted to get
your thoughts on what are the possible places that a list (source) for data
validation can be stored? I am working on someone else's timesheet and when I
click on a cell and check the data validation it is referring to a list that
I can't find. Obviously I checked the one tab, but it had another validation
list. This is a free-floating file, which means it is being copied and saved
all over the organization, so I don't think the list refers to another Excel
file. Any ideas? Thanks!

"Teethless mama" wrote:

=IF(OR(A1={"Holiday","Sick","Personal"}),8,"")


"Outlook, eh?" wrote:

Hello,
I am revamping a timesheet in Excel and was wondering how to make all values
in a list box equal 8.
For example,
I have a drop down box for Holiday, Sick, Personal and when a user selects
one of these types 8 hours will appear in a total hours box.
Any help would be great!
Thx
-B