hi,
anyone knows how to remove the #value i am getting on this formula? =IF(E14<C14,E14+1,E14+F14)-C14
this formula works well, how ever when column D is blank, this is when the #value error appears. I appreciate any response.
thanks,
stoey
hi,
anyone knows how to remove the #value i am getting on this formula? =IF(E14<C14,E14+1,E14+F14)-C14
this formula works well, how ever when column D is blank, this is when the #value error appears. I appreciate any response.
thanks,
stoey
The formula doesn't depend directly on any cell in column D, so you need to back up a step.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks