SUMPRODUCT Problem

[KC]

The formula below doesn't seem to be working. What I want to say is IF O19
is >75% but less than 100% AND V19 is > 100%, then return a 1, otherwise
leave the cell blank. Thanks for your help

=SUMPRODUCT(--(O19>=75%),--(O19<99.999%),--(V19>=100%),1,"")

 

[Peo Sjoblom]

Why wouldn't even be a SUMPRODUCT problem?

=IF(AND(O19>75%,O19<1,V19>1),1,"")

--


Regards,


Peo Sjoblom

 

[Per Jessen]

Hi

Look at this:

=IF(SUMPRODUCT(--(O19>=75%),--(O19<100%),--(V19>=100%))=1,1,"")

Regards,
Per

 

[Tom Hutchins]

Try

=IF(AND(O19>75%,O19<100%,V19>100%),1,"")

Hope this helps,

Hutch