Forum Discussion
How to fix my iferror when having to removed data
My calculation is =IFERROR(C15-B15+1,0) but when I remove that data from a field it leaves 1. I need to calculate the number of checks I am working with so check number 1234 is my beginning check...
EstherMiles Well, blank cells represent a value of zero, so 0-0+1 = 1. Having blank cells doesn't generate an error, so IFERROR does nothing here
Try something like this in stead:
=(C15-B15+1)*NOT(OR(ISBLANK(B15),ISBLANK(C15)))
It will do the calculation provided that both B15 and C16 contain data.