sig figs

mandopolis · Apr 17th, 2002, 02:40 PM

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 · Apr 17th, 2002, 02:47 PM

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 · Apr 17th, 2002, 02:48 PM

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

Ian Mac · Apr 17th, 2002, 02:49 PM

Quote:

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 · Apr 17th, 2002, 02:49 PM

Format C24 as text

s-o-s · Apr 17th, 2002, 02:50 PM

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 · Apr 17th, 2002, 03:44 PM

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 · Apr 18th, 2002, 07:47 AM

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

Jay Petrulis · Apr 21st, 2002, 08:39 PM

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

Apr 17th, 2002, 02:48 PM	#3
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Would just setting the number of decimal places be any use to you? (I know you said "sig fig") __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 17th, 2002, 02:49 PM	#5
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Format C24 as text __________________ Kind regards, Al Chara

Apr 17th, 2002, 02:50 PM	#6
s-o-s Board Regular Join Date: Apr 2002 Location: Kissimmee, Florida Posts: 384	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) __________________ Hope This Helps. Sean. Digest of Homes WinXP, XL XP

Apr 18th, 2002, 07:47 AM	#8
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	How about using: =FIXED($C$24,3) __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 02:40 PM	#1
mandopolis New Member Join Date: Apr 2002 Posts: 9	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!!

Apr 17th, 2002, 02:47 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	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 ]

Apr 17th, 2002, 03:44 PM	#7
mandopolis New Member Join Date: Apr 2002 Posts: 9	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.

Apr 21st, 2002, 08:39 PM	#9
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	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