count if + if....issue

[bluepenink]

Hello i have the following formula, but it appears to not be working correctly.

=IF(COUNTIF(D8:O8,"<=3"),0,IF(E26>=100%,C27/12*COUNTIF(D8:O8,">0"),0))

basically, what i want to show is

if the count D8:O8 is <= 3 then 0,
otherwise
IF(E26>=100%,C27/12*COUNTIF(D8:O8,">0"),0))

can someone pls help with my logic!

thx u

 

[bluepenink]

basically
D8:O8 = months

so im showing the annual bonus...the annual bonus doesnt apply to ppl that have less than 3 months of tenure

so if D8:O8 is <=3 months

then annual bonus is 0

otherwise, calculate bonus using this:
IF(E26>=100%,C27/12*COUNTIF(D8:O8,">0"),0))


can u help!

 

[taurean]

Does this work:
=IF(COUNT(D8:O8)<=3,0,IF(E26>=100%,C27/12*COUNTIF(D8:O8,">0"),0))

 

[Matty]

What, exactly, sits in D8:O8? Text or numbers? And are all Cells populated or just for when an employee has worked?

Posting an example might be best as it will ensure we provide something that suits your needs.

Matty

 

[imcfcl]

In row 7, Do you have like Jan through to Dec and then in row 8 you are putting a '1' to show that the person was there?

If so, then the above works, if you have text in row 8, then you'll need to do something slightly different

 

[bluepenink]

thxs buddy

i made in a mistake in my countif

i had 0, so once i changed it to "" or blanks, the formula worked...thxs alot!