Can´t get any result
 

I'm creating a work chart, and what i want to do is whernever appears Sat or
Sun, if week-off or holidays the result should be 0.

Dia Sem Ent SaÃ*d Ent SaÃ*d
1 6ª
2 Sab Folga
3 Dom
4 2ª
5 3ª
6 4ª
7 5ª
8 6ª 15 23 8
9 Sab 15 23 8
10 Dom 17 23 6

Can´t get any result
 

hi,

did you have a table with the holidays?

looking for Sun or Sat use IF function:

=if(or(b2="sat",b2="sun"),0,"")

note that when you will put the correct figure (i.é 15,23, etc) the formula
will be erased.

hth
regards from Brazil
Marcelo

"The Mole" escreveu:

I'm creating a work chart, and what i want to do is whernever appears Sat or
Sun, if week-off or holidays the result should be 0.

Dia Sem Ent SaÃ*d Ent SaÃ*d
1 6ª
2 Sab Folga
3 Dom
4 2ª
5 3ª
6 4ª
7 5ª
8 6ª 15 23 8
9 Sab 15 23 8
10 Dom 17 23 6

Can´t get any result
 

"Marcelo" escreveu:

hi,

did you have a table with the holidays?

looking for Sun or Sat use IF function:

=if(or(b2="sat",b2="sun"),0,"")

note that when you will put the correct figure (i.é 15,23, etc) the formula
will be erased.

hth
regards from Brazil
Marcelo

"The Mole" escreveu:

I'm creating a work chart, and what i want to do is whernever appears Sat or
Sun, if week-off or holidays the result should be 0.

Dia Semana SaÃ*da Entrada SaÃ*da Horas
1 6ª
2 Sab Folga 0
3 Dom
4 2ª
5 3ª
6 4ª
7 5ª
8 6ª 15 23 8
9 Sab Férias 0
10 Dom 17 23 6


Thanks, but what i need is something like this:whenever the words Férias or
Folga appear in the sme row of Sab or Dom the rul in the last row should be 0.

Once again thank you.
Best regards
Portugal

Can´t get any result
 

Então Mole, vamos tentar o seguinte:

se bem entendi a fórmula da coluna "horas" deveria ter o seguinte:

=se(e(ou(c79="Sáb";c79="Dom");ou(e79="Férias";e7 9="Folga"));0;"número de
horas")

ou

=if(and(or(c79="Sáb",c79="Dom"),or(e79="Férias", e79="Folga")),0,"número de
horas")

se o seu excel estiver em inglês.

espero tê-lo ajudado, e aqui no Brasil todos estamos a torcer por Portugal.
um abraço
Marcelo

"The Mole" escreveu:



"Marcelo" escreveu:

hi,

did you have a table with the holidays?

looking for Sun or Sat use IF function:

=if(or(b2="sat",b2="sun"),0,"")

note that when you will put the correct figure (i.é 15,23, etc) the formula
will be erased.

hth
regards from Brazil
Marcelo

"The Mole" escreveu:

I'm creating a work chart, and what i want to do is whernever appears Sat or
Sun, if week-off or holidays the result should be 0.

Dia Semana SaÃ*da Entrada SaÃ*da Horas
1 6ª
2 Sab Folga 0
3 Dom
4 2ª
5 3ª
6 4ª
7 5ª
8 6ª 15 23 8
9 Sab Férias 0
10 Dom 17 23 6


Thanks, but what i need is something like this:whenever the words Férias or
Folga appear in the sme row of Sab or Dom the rul in the last row should be 0.

Once again thank you.
Best regards
Portugal