If Statement with two concatenates

[jackfox68]

The bold underlined formula below is equating to 9.63 for the selected fields, which should default to the second concatenate, but for some reason it is defaulting to the first concatenate. Any thoughts on why?


=IF(AA25>0,IF(SUMPRODUCT($W$23:W25,$Y$23:Y25)/SUM($Y$23:Y25)<10,CONCATENATE(":0",ROUND(SUMPRODUCT($W$23:W25,$Y$23:Y25)/SUM($Y$23:Y25),0)),CONCATENATE(":",ROUND(SUMPRODUCT($W$23:W25,$Y$23:Y25)/SUM($Y$23:Y25),0))),"")

 

[Fluff]

Any thoughts on why?

Because 9.63 is less than 10

 

[jackfox68]

Thanks for the reply, even though it didn't answer my question directly it helped me think! I added a round to the if check, which I think will solve my problem

 

[Fluff]

even though it didn't answer my question directly

You said this
SUMPRODUCT($W$23:W25,$Y$23:Y25)/SUM($Y$23:Y25)
returns 9.63
so your formula becomes
IF(9.63<10,...
as 9.63 is less than 10 it returns true, which in turn returns the first concatenate formula

 

[jackfox68]

ok ok , let me rephrase. Even though I did not ask the question in a manner that would get the answer I actually needed....