Rounding

[Curtis]

I have 2 values which I know equal however when I use the round function
below it states it does not equal

=IF(ROUND(BH3,3)<>SUMPRODUCT(--('Jan Data'!$F$3:$F$12230)=$B3)*('Jan
Data'!$N$3:$N$12230=FALSE)*('Jan Data'!$I$3:$I$12230),"not balanced","")

What am I doing wrong

thanks

 

[Fred Smith]

1. Your parentheses are out of order. Try:
=IF(ROUND(BH3,3)<>SUMPRODUCT(('Jan Data'!$F$3:$F$12230=$B3)*('Jan
Data'!$N$3:$N$12230=FALSE)*('Jan Data'!$I$3:$I$12230)),"not balanced","")
(BTW, in a Sumproduct, you either multiply with *, or use unary --, not
both)

2. I would think that you need to Round the Sumproduct result as well.

Regards,
Fred

 

[Curtis]

Disregard....Figured it out...Thanks

 

[Duke Carey]

You should round() the sumproduct(), too, to the same number of decimals

to troubleshoot this on your own you could put your sumproduct formula in a
cell by
itself and set the format to something with well over 3 decimals and you'd
almost certainly find that it is not equal to the comparison value.