Excel Formulars Watch

Mike1211
Badges: 5
Rep:
?
#1
Report Thread starter 6 months ago
#1
Hi Guys, I need some help with formulas on excel.

I am trying to have data in a cell round up to the nearest 0.5
One cell has 1.33333 in it.
in a cell underneath , I want the value to display as 1.5 in it

similarly if a cell had 1.65, I want another cell underneath to display as 2.

my code here =ROUNDUP(D10,0) , =ROUNDUP(D10,0.5)
and =ROUNDUP(D10,1)
only ever makes the value go up to 2, or 1.4 .

IS there a way of making that cell go up just to the nearest 0.5?
Please help
0
reply
winterscoming
Badges: 18
Rep:
?
#2
Report 6 months ago
#2
Try using the CEILING function instead. Here's the official documentation:
https://support.office.com/en-us/art...c-c943e510899f

Using your example with cell 'D10':
Code:
=CEILING(D10, 0.5)
1
reply
Mike1211
Badges: 5
Rep:
?
#3
Report Thread starter 6 months ago
#3
Thanks for that, That's the one I needed. Haven't used excel in years so this was new to me haha
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

University open days

  • Solent University
    Postgraduate and Professional Open Evenings Postgraduate
    Mon, 25 Mar '19
  • Cardiff University
    Undergraduate Open Day Undergraduate
    Wed, 27 Mar '19
  • University of Portsmouth
    Postgraduate and Part-Time Open Evenings Postgraduate
    Wed, 27 Mar '19

Where do you need more help?

Which Uni should I go to? (159)
18.62%
How successful will I become if I take my planned subjects? (84)
9.84%
How happy will I be if I take this career? (142)
16.63%
How do I achieve my dream Uni placement? (122)
14.29%
What should I study to achieve my dream career? (82)
9.6%
How can I be the best version of myself? (265)
31.03%

Watched Threads

View All
Latest
My Feed