Rounding
 

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

Rounding
 

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" wrote in message
...
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

Rounding
 

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.


"Curtis" wrote:

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

Rounding
 

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

"Curtis" wrote:

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