| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
getting quantities according to date
Hi,
I have an excel sheet with two ranges first one is dates the other one is quantities. while quantities could be negative.I need to count how many days back until the quantity is zeroed. every cell needs to be calculated with above 15 days being equal to one and below 15 days equals to 0.5 I can't seem to find a way to loop a formula onto a range... I wrote this formula to calculate the dates =IF(F7<0,(IF((DATEDIF(F6,G6,"d"))<15,15,30))*(IF(F 7<0,(ABS(F7)))/30),) the date range is F6:AK6 and quantities is F7:AK7 Thanks Ofer |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| getting quantities according to date | Excel Discussion (Misc queries) | |||
| getting quantities according to date | Excel Worksheet Functions | |||
| if duplicates then add quantities? | Excel Programming | |||
| Different quantities of a certain item... | Excel Worksheet Functions | |||
| sum partnumber quantities | Excel Programming | |||
Threaded Mode
