Thread: If Funtion
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David
 
Posts: n/a
Default If Funtion

I have a if function =IF(SUM(F10:F52)=GM!$B$21,GM!$B$21,"wrong sum").
This looks up the some of one sheet and compares it to another to see if
they are the same. To come up with a sum I have different qty's of units.
Some times w. qty of 2 it works but w. qty of 3 it doesn't. 9 decimal places
out is the problem.
348,822.64024607600000000000000000
348,822.64024607500000000000000000
How can I convert this so it only looks at 3 or 4 decimals out.

Thanks