We help IT Professionals succeed at work.

Ignore rounding

Seamus2626
Seamus2626 asked
on
Hi,

In my attachhed spreadsheet you can see my highlighted formula. It is correct in what it is doing, however, i want it to ignore decimals after two places, so if it is 0.00, then the formula should return 0, at the moment it includes all decimals.

So the formula result for C18 should be 0 instead of 10

So i need something added to the formula to achive this

Thanks
Seamus
test.xls
Comment
Watch Question

Most Valuable Expert 2013
Commented:
Hello Seamus, try using ROUND like this

=IF(OR(ROUND(D18,2)>0,ROUND(D18,2)<0),COUNT('GL 1524'!D:D)-1,0)

regards, barry

Author

Commented:
Thanks Barry!