How do I add TRUNC to an existing formular?

[Guest]

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

 

[Guest]

=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

 

[folderol]

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

 

[Guest]

Thank you that did the trick

=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