P
Preplexed
I have this in a cell and want to TRUNC the results
=(($A6*$B$3)-D$5)/($B$3-D$5)
=(($A6*$B$3)-D$5)/($B$3-D$5)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tom Hutchins
=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
=TRUNC((($A6*$B$3)-D$5)/($B$3-D$5),1) truncates to one decimal place,
etc.
Hope this helps,
Hutch
F
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
--------------------
=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
P
Preplexed
Thank you that did the trick
Tom Hutchins said:=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