Decimal Place Rounding
 

Hi,

I have a cell that looks at a cell on another sheet and simply
displays the contents if the conditions are right using an IF
statement.

Problem is, it displays the number as fully expressed
8.989348643268967E-05 and I just want a plain and simple 0.00008.

I have tried formatting the cell as a number and setting the DP and
also leaving it as general, but it still does it.

On the sheet it gets the number from, its displayed as 0.00008.

What am I doing wrong?

Cheers,

Aaron.

Decimal Place Rounding
 

On 3 May 2007 16:37:49 -0700, Aaron wrote:

Hi,

I have a cell that looks at a cell on another sheet and simply
displays the contents if the conditions are right using an IF
statement.

Problem is, it displays the number as fully expressed
8.989348643268967E-05 and I just want a plain and simple 0.00008.

I have tried formatting the cell as a number and setting the DP and
also leaving it as general, but it still does it.

On the sheet it gets the number from, its displayed as 0.00008.

What am I doing wrong?

Cheers,

Aaron.

Post the formula that you are using in that cell.
--ron

Decimal Place Rounding
 

On May 4, 12:18 pm, Ron Rosenfeld wrote:
On 3 May 2007 16:37:49 -0700, Aaron wrote:





Hi,

I have a cell that looks at a cell on another sheet and simply
displays the contents if the conditions are right using an IF
statement.

Problem is, it displays the number as fully expressed
8.989348643268967E-05 and I just want a plain and simple 0.00008.

I have tried formatting the cell as a number and setting the DP and
also leaving it as general, but it still does it.

On the sheet it gets the number from, its displayed as 0.00008.

What am I doing wrong?

Cheers,

Aaron.

Post the formula that you are using in that cell.
--ron- Hide quoted text -

- Show quoted text -

=IF(M27=" "," ",IF(M27="Mettler SG32001 31Kg x 0.1Kg",'Balance SD
Calculator'!C19,(IF(M27="Avery Berkel FA214-A 210g x 0.0001g",'Balance
SD Calculator'!I19,(IF(M27="AND MF6100 6100g x 0.01g",'Balance SD
Calculator'!F19,(IF(M27="Temporary Scale 300kg x 0.05kg",'Balance SD
Calculator'!O19," ")))))))&AK29)

AK29 is just a symbol g, M27 is a pull down validation box that has
the balance text in it as in the IF statement above.

Cheers,

Aaron.

Decimal Place Rounding
 

Concatenation makes the result of your formula text, and therefore unaffected
by number formats. You can format the numeric portion of the formula (before
concatenting it) via the TEXT() function.

Jerry

"Aaron" wrote:

On May 4, 12:18 pm, Ron Rosenfeld wrote:
On 3 May 2007 16:37:49 -0700, Aaron wrote:





Hi,

I have a cell that looks at a cell on another sheet and simply
displays the contents if the conditions are right using an IF
statement.

Problem is, it displays the number as fully expressed
8.989348643268967E-05 and I just want a plain and simple 0.00008.

I have tried formatting the cell as a number and setting the DP and
also leaving it as general, but it still does it.

On the sheet it gets the number from, its displayed as 0.00008.

What am I doing wrong?

Cheers,

Aaron.

Post the formula that you are using in that cell.
--ron- Hide quoted text -

- Show quoted text -

=IF(M27=" "," ",IF(M27="Mettler SG32001 31Kg x 0.1Kg",'Balance SD
Calculator'!C19,(IF(M27="Avery Berkel FA214-A 210g x 0.0001g",'Balance
SD Calculator'!I19,(IF(M27="AND MF6100 6100g x 0.01g",'Balance SD
Calculator'!F19,(IF(M27="Temporary Scale 300kg x 0.05kg",'Balance SD
Calculator'!O19," ")))))))&AK29)

AK29 is just a symbol g, M27 is a pull down validation box that has
the balance text in it as in the IF statement above.

Cheers,

Aaron.

Decimal Place Rounding
 

On May 4, 1:32 pm, Jerry W. Lewis wrote:
Concatenation makes the result of your formula text, and therefore unaffected
by number formats. You can format the numeric portion of the formula (before
concatenting it) via the TEXT() function.

Jerry



"Aaron" wrote:
On May 4, 12:18 pm, Ron Rosenfeld wrote:
On 3 May 2007 16:37:49 -0700, Aaron wrote:

Hi,

I have a cell that looks at a cell on another sheet and simply
displays the contents if the conditions are right using an IF
statement.

Problem is, it displays the number as fully expressed
8.989348643268967E-05 and I just want a plain and simple 0.00008.

I have tried formatting the cell as a number and setting the DP and
also leaving it as general, but it still does it.

On the sheet it gets the number from, its displayed as 0.00008.

What am I doing wrong?

Cheers,

Aaron.

Post the formula that you are using in that cell.
--ron- Hide quoted text -

- Show quoted text -

=IF(M27=" "," ",IF(M27="Mettler SG32001 31Kg x 0.1Kg",'Balance SD
Calculator'!C19,(IF(M27="Avery Berkel FA214-A 210g x 0.0001g",'Balance
SD Calculator'!I19,(IF(M27="AND MF6100 6100g x 0.01g",'Balance SD
Calculator'!F19,(IF(M27="Temporary Scale 300kg x 0.05kg",'Balance SD
Calculator'!O19," ")))))))&AK29)

AK29 is just a symbol g, M27 is a pull down validation box that has
the balance text in it as in the IF statement above.

Cheers,

Aaron.- Hide quoted text -

- Show quoted text -

Yes of course, I didnt think of this I have altered a line with the
following

TEXT('Balance SD Calculator'!I19,"0.00000")

and it is working fine now.

Many thanks.