Rounding

  • Thread starter Thread starter Curtis
  • Start date Start date
C

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
 
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
 
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.
 
Back
Top