Hello all.
I am new to the forum and hope I am doing okay at the moment!!!
I am having a problem on a sheet. I have input a formula and the number doesnt usually come back as a whole number so I have formatted cells and made it to 0 decimal places. How ever I have a dropdown menu with numbers 1 - 15. This rounded value will be multiplied by the value seleted.
The problem I am getting is, when the number is 1 and the value rounded is say for example 4.5 the answer is 5 and this is correct. But if I am multiplying by 2 the answer will show 9 (4.5*2) and not 10 (5*2).
I hope this makes sense and hope you can help.
Thanks in advance!
Bookmarks