I have this in a cell and want to TRUNC the results
=(($A6*$B$3)-D$5)/($B$3-D$5)

=TRUNC((($A6*$B$3)-D$5)/($B$3-D$5),0) truncates to zero decimal places,
=TRUNC((($A6*$B$3)-D$5)/($B$3-D$5),1) truncates to one decimal place,
etc.

Hope this helps,

Hutch

"Preplexed" wrote:

I have this in a cell and want to TRUNC the results
=(($A6*$B$3)-D$5)/($B$3-D$5)

Code:
--------------------

=trunc((($A6*$B$3)-D$5)/($B$3-D$5),0)
or
=int((($A6*$B$3)-D$5)/($B$3-D$5))
or
=round((($A6*$B$3)-D$5)/($B$3-D$5),0)

--------------------


If you look trunc() up in help it discusses the differences. Trunc
supports precision, so you can truncate at any decimal position, while
int truncates all the decimal positions.

Tom


--
folderol
------------------------------------------------------------------------
folderol's Profile: http://www.excelforum.com/member.php...o&userid=37288
View this thread: http://www.excelforum.com/showthread...hreadid=570022

Thank you that did the trick

"Tom Hutchins" wrote:

=TRUNC((($A6*$B$3)-D$5)/($B$3-D$5),0) truncates to zero decimal places,
=TRUNC((($A6*$B$3)-D$5)/($B$3-D$5),1) truncates to one decimal place,
etc.

Hope this helps,

Hutch

"Preplexed" wrote:

I have this in a cell and want to TRUNC the results
=(($A6*$B$3)-D$5)/($B$3-D$5)