hi to all,
i have a file in which there are some works. in sheet 1 column c is work planned date and column d is actual work done date. and column e is the difference between planed date and actual date named as delay. in sheet 2 there are weekly scoring according to planned date and actual date.
for example:- if any work has to be done on 10/8/2019 (this is our planned date). but the work is getting done on 10/12/2019. so the delay time is 4 days and this will review in sheet 2 how much % the work is getting late and there were how many works in any particular week..
my real problem is that when there is no planned date or actual date then it shows #N/A in that particular week.( please see AI4, AI5 and there are many more.) i want that this error should not be shown up if there are not any work its should show up the value 0 but don't want to use iferror function. because when we use -iferror it shows 0 but my formula auto calculate in minus. so it starts to show up the result in plus. (without -if error result is coming -75%, and with -iferror result comes 75% which is wrong.) so i want any change in formula that it can show up 0 if there is not any work in any particular week and want this thing for all the #N/A. https://docs.google.com/spreadsheets...#gid=858972579
Bookmarks