Posted to microsoft.public.excel.worksheet.functions

Susi

external usenet poster

Posts: 6

Formula Entry

How can I get this formula to return a Rounded Down to an Whole Number?

=IF(($I14-$A14)<0,IMABS($I14-$A14)*0.8,"")

Thanks

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 to repeat the upper row formula without entry formula?	LPCHUA ^_^	Excel Discussion (Misc queries)	1	July 27th 08 01:05 PM
Prevent formula entry	news.freedom2surf.net	Excel Worksheet Functions	4	June 22nd 07 04:42 AM
Formula doesn't find last entry	caj	Excel Discussion (Misc queries)	3	September 25th 06 07:34 PM
Formula for duplicate entry	Calculate Date range	Excel Worksheet Functions	1	April 7th 06 02:35 AM
Daily entry formula	gutenburg	Excel Discussion (Misc queries)	0	January 31st 06 11:24 PM

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

About Us

"It's about Microsoft Excel"