SUMPRODUCT Problem
 

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,"")

SUMPRODUCT Problem
 

Why wouldn't even be a SUMPRODUCT problem?

=IF(AND(O1975%,O19<1,V191),1,"")

--


Regards,


Peo Sjoblom


"KC" wrote in message
...
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,"")

SUMPRODUCT Problem
 

Hi

Look at this:

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

Regards,
Per

"KC" skrev i meddelelsen
...
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,"")

SUMPRODUCT Problem
 

Try

=IF(AND(O1975%,O19<100%,V19100%),1,"")

Hope this helps,

Hutch

"KC" wrote:

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,"")