Hi guys,
Sorry to post another question but I'm stuck again!
Let's say I have '20' in cell A1 and '2.8455' in cell A2.
I want to multiply 20 x 2 and ignore the .8455.
When I get rid of decimal places, it rounds 20 up to 21, which isn't what I need really.
Is there a way to multiply by just the number before the decimal point and ignore everything after it?
Thank you so much!
Skye
Bookmarks