| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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,"") |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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,"") |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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,"") |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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,"") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT problem | Excel Worksheet Functions | |||
| SUMPRODUCT #VALUE! problem | Excel Worksheet Functions | |||
| SUMPRODUCT PROBLEM | Excel Worksheet Functions | |||
| SUMPRODUCT Problem | Excel Discussion (Misc queries) | |||
| SUMPRODUCT problem | Excel Worksheet Functions | |||
Hybrid Mode
