Hi

It quite rightly returns 2 for me. Are you sure that's what you have
typed in your cell? What happens if you press F9?

--
Regards

Roger Govier


M8 wrote
I can't get ROUNDDOWN to work with embedded operations.
For instance:
=ROUNDDOWN(7-1,0) returns 6
BUT
=ROUNDDOWN(((7-1)/3),0) will return 1 instead of 2
what is going on?