SUMPRODUCT Problem

  • Thread starter Thread starter KC
  • Start date Start date
K

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,"")
 
Why wouldn't even be a SUMPRODUCT problem?

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

--


Regards,


Peo Sjoblom
 
Hi

Look at this:

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

Regards,
Per
 
Back
Top