Hi,
can you help with formula to round up with condtion:
1. If decimal amount is less than 50 - cut it, example: 15,49 => 15,00
2. If decimal amount is more or equal 50 - round it up, example : 15,50 => 16,00
Please help,
Best,
Jacek
Hi,
can you help with formula to round up with condtion:
1. If decimal amount is less than 50 - cut it, example: 15,49 => 15,00
2. If decimal amount is more or equal 50 - round it up, example : 15,50 => 16,00
Please help,
Best,
Jacek
That's how ROUND works by default, so just:
=ROUND(A1,0)
for example.
Rory
oo thank you, i was using RoundUp instead of this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks