Forum Discussion
Help with formula not working anymore.
Not sure why but for months this has worked for me doing roof material orders. But today I open it and get NAME error and cannot see the issue. maybe someone who can see the formula differently than me can help. I have attached below the workbook, Thanks for any help I can get on this.
=IF(AND(ISBLANK(B6),ISBLANK(K6)),"",CEILING(E8,1/3))
Does this return the intended result?
