Posted to microsoft.public.excel.misc

Preplexed

external usenet poster

Posts: 2

How do I add TRUNC to an existing formular?

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do i TRUNC a date field using SQL Server ODBC ?	Nick Newton	Excel Discussion (Misc queries)	0	June 22nd 06 02:17 PM
excel formular update	bluesky	Excel Worksheet Functions	1	April 4th 06 03:33 AM
Reducing Formular length	Nello	Excel Discussion (Misc queries)	2	June 15th 05 06:32 PM
Adding more source data to existing scatter plot	Tom	Charts and Charting in Excel	1	March 21st 05 10:03 PM
How to protect the formular	joy	Excel Discussion (Misc queries)	1	February 20th 05 05:12 AM

All times are GMT +1. The time now is 03:10 PM.

About Us

"It's about Microsoft Excel"