sig figs

[mandopolis]

in one of the true false if statements i am trying to write, i want it to show <0.200
and if $C$24=0.200 and my eqn looks like: "<"&$C$24 it spits out the answer as <.2 this is a real problem for me becuase i am a chemist and i need accuracy with sig figs. ive tried all the number formats, is there any other way this can be written, or am i missing something? PLEASE HELP!! THANX!!

 

[lenze]

Not sure if this is what you want, but try using custom format and enter "<" 0.000 for the cell where the answer is.
Then remove the "<" from your formula.
This message was edited by lenze on 2002-04-17 13:48

 

[Mark O'Brien]

Would just setting the number of decimal places be any use to you? (I know you said "sig fig")

 

[Ian Mac]

On 2002-04-17 13:40, mandopolis wrote:
in one of the true false if statements i am trying to write, i want it to show <0.200
and if $C$24=0.200 and my eqn looks like: "<"&$C$24 it spits out the answer as <.2 this is a real problem for me becuase i am a chemist and i need accuracy with sig figs. ive tried all the number formats, is there any other way this can be written, or am i missing something? PLEASE HELP!! THANX!!

what about:

="<"&TEXT($C$24,"0.000")

 

[Al Chara]

Format C24 as text

 

[s-o-s]

If you just want to see that it does equal 0.2000

You could use the formula

="<"&text($C$24,"0.000000000000")

This will give you as many decimals as you want (Subject to system limits)

 

[mandopolis]

see cell $C$24 is being multiplied by another cell, so i need 3 places to the right of the decimal no matter what the result, sorry for the miscommunication.

 

[Al Chara]

How about using:
=FIXED($C$24,3)

 

[Jay Petrulis]

Hi,

With your raw data in A1 and the number of significant figures you desire in B1, try:

=ROUND(A1,B1-1-INT(LOG10(ABS(A1))))

Bye,
Jay