I have a cell that shows =IF(ISBLANK($E12),1,0) I have another that shows =IF($E4="Total:",1,0)

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.


This'll do the trick:

|improve this answer|||||
  • I've done some programming in the past, sometimes I really miss the IFWhile loops. Thanks. – Matt Ridge Sep 20 '12 at 18:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.