Drop down lists & formulas

[Guest]

Can I create a drop down list in a worksheet and link the names/titles in that drop down list to different formulas?????

 

[Vasant Nanavati]

What do you mean by "link the names/titles in that drop down list to
different formulas"???

--

Vasant

Can I create a drop down list in a worksheet and link the names/titles in

that drop down list to different formulas?????

 

[firefytr]

if you mean can a formula use a value from a drop down list (eg dat
validation) in a formula, sure, just reference the cell, works as
*value*, not a *formula*.

specifics? post some details.

HT

 

[Otto Moehrbach]

Do you mean you want to have a formula in some cell that references the
contents of another cell that has a drop-down list to choose from? Yes.

Can I create a drop down list in a worksheet and link the names/titles in

that drop down list to different formulas?????

 

[Guest]

Thanks for your reply it is appreciated

The next question is how do I do it

Hope you can assist

----- Otto Moehrbach wrote: ----

Do you mean you want to have a formula in some cell that references th
contents of another cell that has a drop-down list to choose from? Yes

Can I create a drop down list in a worksheet and link the names/titles i

that drop down list to different formulas????

 

[Guest]

Thanks for your reply, its appreciated
I am trying to create an employee timesheet
When an employee is away sick or on annnual leave ect I need to post the hours they are either sick or on annual leave to a different cell than the hours they work
What I want to do is create a drop down list immediately under the column that represents the day ie; 21/03 so that it tells me that they were away sick on that day and the hours for that day are posted to a cell which indicates how many hours they were sick
The problem is I will have a few titles in the drop down list like annual leave sick leave ect. and each one of these requires a different formula. I am trying to link the drop down list with multiple options ie; sick leave annual leave ect. with a formula for each of these categories
Can this be done and how do I do it
Hope you can assist, thanks in advance

----- firefytr > wrote: ----

if you mean can a formula use a value from a drop down list (eg dat
validation) in a formula, sure, just reference the cell, works as
*value*, not a *formula*

specifics? post some details

HT

 

[Otto Moehrbach]

Gary
I'm lost as to what you have (data layout) and what you want to do.
From what you say, I envision that you have the days of a month in a
row, as dates. Is that correct?
You want to put a drop-down list under each date, with a choice of
Annual, Sick, etc.
You would select that cell and click on the drop-down arrow and select
one of the items in the list.
Here is where I get lost. What is it that you want to happen at this
point?
Do this. Forget about the formulas. Forget about entering the hours.
Just tell me what you want to happen rather than how you want it to happen.
You want something to appear in some cell.
What cell?
What do you want to appear? Exactly. Write it out.

You say:
" The problem is I will have a few titles in the drop down list like annual
leave sick leave ect. and each one of these requires a different formula. I
am trying to link the drop down list with multiple options ie; sick leave
annual leave ect. with a formula for each of these categories."
This statement is what is confusing. You say "different formulas".
Exactly what is it that you want these "different formulas" to display or
do?
When the drop-down is "Sick Leave", exactly what do want to see and where do
you want to see it?
I'm sure that what you want to do can be done, but remember that of the
two of us, you're the only one that knows your business. HTH Otto

Thanks for your reply, its appreciated.
I am trying to create an employee timesheet.
When an employee is away sick or on annnual leave ect I need to post the

hours they are either sick or on annual leave to a different cell than the
hours they work.

What I want to do is create a drop down list immediately under the column

that represents the day ie; 21/03 so that it tells me that they were away
sick on that day and the hours for that day are posted to a cell which
indicates how many hours they were sick.

The problem is I will have a few titles in the drop down list like annual

leave sick leave ect. and each one of these requires a different formula. I
am trying to link the drop down list with multiple options ie; sick leave
annual leave ect. with a formula for each of these categories.

 

[Guest]

To Ott
i tied to explain it better

Thanks for your reply, its appreciated
I am trying to create an employee timesheet
When an employee is away sick or on annnual leave ect I need to post th

hours they are either sick or on annual leave to a different cell than th
hours they work

What I want to do is create a drop down list or something like it immediately under the colum

that represents the day ie; 21/03 so that it tells me that they were awa
sick on that day and the hours for that day are posted to a cell whic
indicates how many hours they were sick

The problem is I will have a few titles in the drop down list like annua

leave sick leave ect. and each one of these requires to go to a different cell.
so will have 4 choices sick leave, public holiday worked, public holiday not worked
each of these need to do a different process ie SL if this is selected then i need data from C4 to go into G
and if PHW is selected then i need to take that same data form C4 and put it into G3 etc.