I am using the formula =IF(E4<>"X",1,IF(F4<>"X",1,0)) to populate data on another sheet. This form is reused so when I clear the old data I don't want the false information posting over. I am having trouble getting isblank to work. Any help would be appreciated.
Maybe this?Formula:
Please Login or Register to view this content.
Dave
Here's another one...
=IF(E4&F4="","",--(COUNTIF(E4:F4,"<>X")>0))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks