Thread: Rounding
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Curtis Curtis is offline
external usenet poster
 
Posts: 181
Default 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