Posted to microsoft.public.excel.misc

amaal titi amaal titi is offline

external usenet poster

Posts: 1

i need a fuction

i would be grateful if any one can help with this...i am making a function to
subtract between two dates(date - date1) and then subtract from 6 if it is
less than 0 then true 0 if other wise then the function (date-date1)-6
=((if(L:L-C:C)-6<0,0,(L:L-C:C)-6) this is the funtion but it gives wrong?
--
eng.amaal titi

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
Min Fuction	rustygun3	Excel Worksheet Functions	1	June 7th 07 11:35 PM
Which fuction!	Be18	Excel Worksheet Functions	2	April 27th 07 01:43 AM
if fuction	Lakebum	Excel Worksheet Functions	4	December 7th 05 12:42 PM
need a fuction that can do this (or can it be done)	Mrbanner	Excel Worksheet Functions	3	August 1st 05 04:07 AM
For Each Fuction???	Dave_2k5	Excel Discussion (Misc queries)	11	July 26th 05 12:05 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us