Hello Forum
Just took on a new workbook and noticed that the person before did not build their formulas for DIV and NA errors.
How can I adjust the following formula to have these areas turn to "0" instead of the errors. Thank you
=VLOOKUP($J$1,Today_FOOD,10,FALSE)/VLOOKUP($J$1,Today_FOOD,9,FALSE)
=(VLOOKUP($C8,Today_FOOD,37,FALSE))/(VLOOKUP($C8,Today_FOOD,36,FALSE))
=VLOOKUP($C15,Today_FOOD,17,FALSE)
Just took on a new workbook and noticed that the person before did not build their formulas for DIV and NA errors.
How can I adjust the following formula to have these areas turn to "0" instead of the errors. Thank you
=VLOOKUP($J$1,Today_FOOD,10,FALSE)/VLOOKUP($J$1,Today_FOOD,9,FALSE)
=(VLOOKUP($C8,Today_FOOD,37,FALSE))/(VLOOKUP($C8,Today_FOOD,36,FALSE))
=VLOOKUP($C15,Today_FOOD,17,FALSE)