starlinggirl
New Member
- Joined
- Jan 8, 2020
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Hi all,
Possibly a very obvious question. I have a long list of prices which are the result of an IF function to apply certain discount, currently formatted as currency with two decimal places (£14.95). I'd like to round them to the nearest whole number but retain the decimal places (i.e. £15.00 not £15). Is there a quick/easy way to do this?
Thanks in advance!
Possibly a very obvious question. I have a long list of prices which are the result of an IF function to apply certain discount, currently formatted as currency with two decimal places (£14.95). I'd like to round them to the nearest whole number but retain the decimal places (i.e. £15.00 not £15). Is there a quick/easy way to do this?
Thanks in advance!