hi thanks for your help,the problem i am getting is when i use either int or
roundown it trims of the decimal piont but when it is a full digit ie 1 it
puts it to 0
thanks jnf
It could be that the number is actually less than 1 - but is formatted to
show 0 decimal places. If the number was 0.9966 and was formatted to show 0
decimal places, it would display 1 but an INT() on it would give you 0
hi thanks for help, you are right i have tried it with a clean number and it
works, i think my problem is it could be a calculation from antother cell
thank jnf
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.