Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Excel help

Old 11-13-04, 05:16 PM
  #1  
DVD Talk Gold Edition
Thread Starter
 
Join Date: Sep 2002
Posts: 2,187
Likes: 0
Received 0 Likes on 0 Posts
Excel help

Hey there.

I am working with some spreadsheets, and I need Excel to round to the nearest 2,5.

For instance, I type in the number 102,5 in field A6.

The formula for getting 70% of field A6 is =a6*0,7

but that gives me 73,5 I want it to round to the nearest 2,5, in this case 75.

How do I do this?
Old 11-13-04, 06:37 PM
  #2  
Stealth Moderator
 
namja's Avatar
 
Join Date: Oct 1999
Location: In Transit, HQ
Posts: 25,006
Received 2 Likes on 2 Posts
Re: Excel help

Originally posted by Parcher
Hey there.

I am working with some spreadsheets, and I need Excel to round to the nearest 2,5.

For instance, I type in the number 102,5 in field A6.

The formula for getting 70% of field A6 is =a6*0,7

but that gives me 73,5 I want it to round to the nearest 2,5, in this case 75.

How do I do this?
First of all, if you get 73,5 as 70% of 102,5, then you have bigger problems. 102,5 * 0,7 = 71,75. Anyhoo

Here's a work around. For the formula for getting 70% of field A6, type in:

=ROUND(A6*0,7/2,5;0)*2,5

This will round the figure to the nearest 2,5.
Old 11-13-04, 07:00 PM
  #3  
DVD Talk Gold Edition
Thread Starter
 
Join Date: Sep 2002
Posts: 2,187
Likes: 0
Received 0 Likes on 0 Posts
Yeah my bad, ha da different number typed in.

Just for the sake of avoiding confusion, the field is actually B27, but even when I copy-paste

=ROUND(B27*0,7/2,5;0)*2,5

in the field where i want the 70% to go it doesn't work... can't translate the error message as it's not in English, but it's the equivalent of "Name" or "word" or something like that.
Old 11-13-04, 08:38 PM
  #4  
Stealth Moderator
 
namja's Avatar
 
Join Date: Oct 1999
Location: In Transit, HQ
Posts: 25,006
Received 2 Likes on 2 Posts
It works on my Excel. I uploaded my file here. See if this file makes any sense:

http://www.coldpumpkin.com/forum/parcher.xls

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.