if(countif(if...logic help

**step_one** · 09-23-2011, 11:18 AM

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

**daddylonglegs** · 09-23-2011, 11:22 AM

In words the first part of your formula is doing this...

"If D8:O8 contains any numbers less than or equal to three the return a zero......otherwise evaluate this IF function"

perhaps that isn't what you want - can you elucidate - I don't understand what this part means:

if the count D8:O8 is <= 3.....

**step_one** · 09-23-2011, 11:25 AM

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!

**step_one** · 09-23-2011, 11:37 AM

i tried this approach, but no having much luck either...

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

**daddylonglegs** · 09-23-2011, 11:41 AM

So what values do you actually have in D8:O8 - are they 1s and zeroes or something else?

**step_one** · 09-23-2011, 11:46 AM

hello thxs for the help with that....

i made in a mistake in my countif

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