Reference, Questions and Help > Computer Help

3 Questions...

(1/1)

**PapaBear765**:

1. Does anyone have knowledge of how to get Excel to statistically round? That is, always rounding to the even increment when the calculated value is half way. For example: when rounding to nearest 1/10, for 2.25 normal rounding would yield 2.3 but statistical rounding yields 2.2. For 2.75, normal yields 2.8 as well as statistical yielding 2.8. So when x.x5 is calculated, round to the nearest even 1/10, when greater than 5 round up, and when less than 5 round down.

2. Does anyone know of what features are available for all of the levels of service for Google Earth? Are the more expensive services worth the money?

3. How do I get my Yahoo emails to come in to Outlook? I found out the process, but the step when you enter the URL that Outlook will use, but I don't know what the URL should be.

Thanks,

Donovan

**Rennhack**:

--- Quote from: PapaBear765 on Jan 26, 2008, 09:48 ---1. Does anyone have knowledge of how to get Excel to statistically round? That is, always rounding to the even increment when the calculated value is half way. For example: when rounding to nearest 1/10, for 2.25 normal rounding would yield 2.3 but statistical rounding yields 2.2. For 2.75, normal yields 2.8 as well as statistical yielding 2.8. So when x.x5 is calculated, round to the nearest even 1/10, when greater than 5 round up, and when less than 5 round down.

--- End quote ---

I'm not familiar with what you describe as "statistically round", here is a link to some of their rounding functions:

http://www.ozgrid.com/Excel/excel-rounding.htm

You can write yoyur own formula to do what you want with a combination of those functions.

--- Quote from: PapaBear765 on Jan 26, 2008, 09:48 ---2. Does anyone know of what features are available for all of the levels of service for Google Earth? Are the more expensive services worth the money?

--- End quote ---

The more expensive features are targeted at realestate profesionals, and the like. Here is a link to the descriptions of what each does:

http://earth.google.com/product_comparison.html

--- Quote from: PapaBear765 on Jan 26, 2008, 09:48 ---3. How do I get my Yahoo emails to come in to Outlook? I found out the process, but the step when you enter the URL that Outlook will use, but I don't know what the URL should be.

--- End quote ---

If tyou have regular yahoo mail, that option is not available. It you have the paid version, follow these instructions:

http://help.yahoo.com/l/us/yahoo/mail/original/mailplus/pop/pop-08.html

All of these answers were found googling: "yahoo outlook", "google earth", and

**G-reg**:

--- Quote from: PapaBear765 on Jan 26, 2008, 09:48 ---1. Does anyone have knowledge of how to get Excel to statistically round? That is, always rounding to the even increment when the calculated value is half way. For example: when rounding to nearest 1/10, for 2.25 normal rounding would yield 2.3 but statistical rounding yields 2.2. For 2.75, normal yields 2.8 as well as statistical yielding 2.8. So when x.x5 is calculated, round to the nearest even 1/10, when greater than 5 round up, and when less than 5 round down.

--- End quote ---

--- Quote from: Rennhack on Jan 26, 2008, 11:01 ---here is a link to some of their rounding functions:

http://www.ozgrid.com/Excel/excel-rounding.htm

--- End quote ---

Are you always rounding to ONE decimal place? If so, "=MROUND(xxxx.xx,0.2)" will do what you want.

If you are using a variable number of decimal places, or cannot install the MROUND() Add-In, then it's going to get quite a bit trickier. (PM me if you can't get MROUND() to do what you need.)

- Greg

**shayne**:

Round is something that I have used in the past...

From excel help

--- Quote ---Rounds a number to a specified number of digits.

Syntax

ROUND(number,num_digits)

Number is the number you want to round. I use the cell here

Num_digits specifies the number of digits to which you want to round number.

Remarks

If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.

If num_digits is 0, then number is rounded to the nearest integer.

If num_digits is less than 0, then number is rounded to the left of the decimal point.

Example

--- End quote ---

I use yahoo! in my outlook, but I do pay for pop forwarding. For free pop forwarding, open a gmail (Google) account..

**Rennhack**:

--- Quote from: Shayne on Jan 27, 2008, 02:50 ---I use yahoo! in my outlook, but I do pay for pop forwarding. For free pop forwarding, open a gmail (Google) account..

--- End quote ---

Or a nukeworker.net mail powered by gmail...

Navigation

[0] Message Index

Go to full version