Forum Discussion
My formula will not ignore Text in a drop down function
I am trying to make a staff roster and have a drop down menu that has time values and word values that can be selected. The cell that the menu exists in, is part of a formula, calculating total hours worked. The formula will not work when a word is selected its says "#Value" instead of the total hours. When the times are selected there is not a problem. What can I do to fix this (I have tried searching the internet and am now desperate lol). Please see the photos attached and feel free to ask any questions.
Try putting this formula in E8 and dragging down to E16:
=IFERROR(D8-C8,"")
Try putting this formula in E8 and dragging down to E16:
=IFERROR(D8-C8,"")
That worked perfectly, thank you so much for the fast response :) :) :) !!!
You're welcome. If you need to identify Text vs Numbers in the future you can always use these two functions:
ISTEXT() or ISNUMBER()
