You need to give your numerator some decimal places, at least 2 more
decimal places than you have in your denominator.
Magic will only give you the number of decimals equal to places in the
numerator - places in the denominator or zero places whichever is
greater.
This will fix it.
IFE=P(R,S,IF{([ANS,"my_cm_query"]|0*1.0000^CM)
CM/2.54:2D}^/[ANS%0,"my_in_query"]|0)^#
Joe Cocuzzo
Vice President
NPR Services
Iatric Systems, Inc.
Phone/Fax: (978) 805-4115
Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Web: www.iatric.com <http://www.iatric.com>
________________________________
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Carla Fuller
Sent: Wednesday, January 10, 2007 10:13 AM
To: [email protected]
Subject: cm to inches, problem with decimal
Hi all,
I know one of you has the answer that I can't find, and I need your
help. I have a simple little set up for calculating centimeters into
inches. The problem I am having is that my 2 decimal places always come
out to .00, no matter what! It doesn't matter if my cm are 114 or 112, I
still always get 44.00. Can someone review my attribute and tell me
where my problem lies?
IFE=P(R,S,IF{([ANS,"my_cm_query"]|0^CM)
CM/2.54:2D}^/[ANS%0,"my_in_query"]|0)^#
Thank you!
Katie Wood
Applications Specialist
War Memorial Hospital
500 Osborn Blvd
Sault Ste. Marie, MI 49783
(906) 635-4663
[EMAIL PROTECTED]
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
To subscribe or unsubscribe to the meditech-l, visit MTUsers.COM.
To check the status of the meditech-l, visit MTUsers.NET.
For help, email [EMAIL PROTECTED]
______________________________________
meditech-l mailing list
[email protected]
http://mtusers.com/mailman/listinfo/meditech-l
