Thanks:  0
Likes:  0

1. 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!!

2. 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 ]

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

4. 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!!

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

5. Format C24 as text

6. 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)

7. 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.

=FIXED(\$C\$24,3)

9. 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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•