Logical test returning 0

[rkenn]

I have two forumlas:

Formula 1:
(ROUND(SUMIFS(G:G,A:A,"*YYY*",C:C,"*P10*")/0.05,0)*0.05)

Formula 2:
(1/10*(ROUND(SUMIFS(G:G,A:A,("<>*YYY*"),C:C,"*P10*")/0.05,0)*0.05))

I am trying to perform a logical test to check that Formula 1 is equal to 1/10th of Formula 2. I have used the below formula:

IF((ROUND(SUMIFS(G:G,A:A,"*YYY*",C:C,"*P10*")/0.05,0)*0.05)=(1/10*(ROUND(SUMIFS(G:G,A:A,("<>*YYY*"),C:C,"*P10*")/0.05,0)*0.05)),"TRUE","FALSE")

However, instead of 'True' or 'False', I keep getting a '0'. In the Function Arguments window it says the formula result is 'True', so i dont understand why it doesnt show as 'True' in the spreadsheet.

HELLLPP!

Thanks

 

[Aladin Akyurek]

Try...

=X=Y

instead of

=IF(X=Y,"TRUE","FALSE")