I have a cell that shows
=IF(ISBLANK($E12),1,0) I have another that shows
Is there a way to make them do the same thing, so if the cell shows 0 or Total: it shows 1, otherwise it will show 0, even if there is something else in it.
I thought there was a formula that would do that, but I don't have it in my collection...
If anyone could help scramble up something like that together it be greatly appreciated.