Thread: How do I add TRUNC to an existing formular?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tom Hutchins Tom Hutchins is offline
external usenet poster
  
Posts: 1,069
Default How do I add TRUNC to an existing formular?
=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)
Reply With QuoteReply With Quote