multiple conditions
 

Hello,
I'm working on a attendance and vacation worksheet. The fist tab is a
summary of the other 4 tabs. This very similar to Micosofts tracking
templete1.I'm having trouble with summing multiple worksheet with a if then
statement. Here is what I have so far,
=SUM('1st Q:4th Q'!F6). This works fine. I want to also include if the value
is greater than 2 "verbal warning, grater than 3 "written waning", greater
than 4 "days suspension". I thought about putting the =sum statement in VB,
and use the cell for the =if statement, but I'm not to sure how.
Thank you for you time!

multiple conditions
 

Hi!

If I understand, try this:

=LOOKUP(SUM('1st Q:4th Q'!F6),{0,3,4,5},{"","verbal","written","time off"})

Biff

"Rocket" wrote in message
...
Hello,
I'm working on a attendance and vacation worksheet. The fist tab is a
summary of the other 4 tabs. This very similar to Micosofts tracking
templete1.I'm having trouble with summing multiple worksheet with a if
then
statement. Here is what I have so far,
=SUM('1st Q:4th Q'!F6). This works fine. I want to also include if the
value
is greater than 2 "verbal warning, grater than 3 "written waning", greater
than 4 "days suspension". I thought about putting the =sum statement in
VB,
and use the cell for the =if statement, but I'm not to sure how.
Thank you for you time!

multiple conditions
 

=LOOKUP(SUM('1st Q:4th Q'!F6),{0,3,4,5},{"","verbal","written","time
off"})

=LOOKUP(SUM('1st Q:4th Q'!F6),{0,3,4,5},{"","verbal","written","promote to
CEO"})

<g

Biff

"Biff" wrote in message
...
Hi!

If I understand, try this:

=LOOKUP(SUM('1st Q:4th Q'!F6),{0,3,4,5},{"","verbal","written","time
off"})

Biff

"Rocket" wrote in message
...
Hello,
I'm working on a attendance and vacation worksheet. The fist tab is a
summary of the other 4 tabs. This very similar to Micosofts tracking
templete1.I'm having trouble with summing multiple worksheet with a if
then
statement. Here is what I have so far,
=SUM('1st Q:4th Q'!F6). This works fine. I want to also include if the
value
is greater than 2 "verbal warning, grater than 3 "written waning",
greater
than 4 "days suspension". I thought about putting the =sum statement in
VB,
and use the cell for the =if statement, but I'm not to sure how.
Thank you for you time!

multiple conditions
 

"Biff" wrote:

=LOOKUP(SUM('1st Q:4th Q'!F6),{0,3,4,5},{"","verbal","written","time
off"})

=LOOKUP(SUM('1st Q:4th Q'!F6),{0,3,4,5},{"","verbal","written","promote to
CEO"})

<g

Biff

"Biff" wrote in message
...
Hi!

If I understand, try this:

=LOOKUP(SUM('1st Q:4th Q'!F6),{0,3,4,5},{"","verbal","written","time
off"})

Biff

"Rocket" wrote in message
...
Hello,
I'm working on a attendance and vacation worksheet. The fist tab is a
summary of the other 4 tabs. This very similar to Micosofts tracking
templete1.I'm having trouble with summing multiple worksheet with a if
then
statement. Here is what I have so far,
=SUM('1st Q:4th Q'!F6). This works fine. I want to also include if the
value
is greater than 2 "verbal warning, grater than 3 "written waning",
greater
than 4 "days suspension". I thought about putting the =sum statement in
VB,
and use the cell for the =if statement, but I'm not to sure how.
Thank you for you time!




This work great! Thanks again for the quick responce.

multiple conditions
 

You're welcome. Thanks for the feedback!

Biff

"Rocket" wrote in message
...


"Biff" wrote:

=LOOKUP(SUM('1st Q:4th Q'!F6),{0,3,4,5},{"","verbal","written","time
off"})

=LOOKUP(SUM('1st Q:4th Q'!F6),{0,3,4,5},{"","verbal","written","promote
to
CEO"})

<g

Biff

"Biff" wrote in message
...
Hi!

If I understand, try this:

=LOOKUP(SUM('1st Q:4th Q'!F6),{0,3,4,5},{"","verbal","written","time
off"})

Biff

"Rocket" wrote in message
...
Hello,
I'm working on a attendance and vacation worksheet. The fist tab is a
summary of the other 4 tabs. This very similar to Micosofts tracking
templete1.I'm having trouble with summing multiple worksheet with a if
then
statement. Here is what I have so far,
=SUM('1st Q:4th Q'!F6). This works fine. I want to also include if the
value
is greater than 2 "verbal warning, grater than 3 "written waning",
greater
than 4 "days suspension". I thought about putting the =sum statement
in
VB,
and use the cell for the =if statement, but I'm not to sure how.
Thank you for you time!




This work great! Thanks again for the quick responce.