Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
i need a fuction
=MAX(0,(L1-C1-6)
L1 is latest data C1 is oldest date and copy down Your formula was attempting to subtract a whole column (C:C:) from another column (L:L) "amaal titi" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Min Fuction | Excel Worksheet Functions | |||
Which fuction! | Excel Worksheet Functions | |||
if fuction | Excel Worksheet Functions | |||
need a fuction that can do this (or can it be done) | Excel Worksheet Functions | |||
For Each Fuction??? | Excel Discussion (Misc queries) |