Dear Members,
i want to apply a formula on attach sheet to get 3DMA(7 day moving average) & 7DMA(7 day moving average).
problem is highlighed cells(A2:A6) repeat because the stock data is for the period 08Jan to 21Jan.
Regards,
Deepak
Problem = I have a Fix AR Date in one cell and also have due date of invoices, in Due date column some cells have #n/a error. By use of IF(ISERROR) function i want if cells have any error then it returns Due, if AR Date is less than equal to due date (< or =)then it returns Due otherwise Not...