One way (assumes we're working in row 2) =IF(AND(LEN(A2)>0,LEN(B2)>0,LEN(C2)>0),1,0) "wx4usa" <wx4usa@gmail.com> wrote in message news:1187916839.800526.170900@m37g2000prh.googlegroups.com... I have 3 columns with misc data. Column A is a date, column B is an invoice number and C is an expense report number. If all 3 columns have data entered, I would like to have a formula return

TwoBrains wrote: "A Veteran" <georgek@humboldt1.com> wrote in message news:georgek-800526.08512310052007@sn-ip.vsrv-sjc.supernews.net... In article <AvG0i.5436$H_.4356@newssvr21.news.prodigy.net>, "TwoBrains" <Condi republican-AlQueda@FoxNews.net> wrote: The White House session demonstrated the grave unease many Republicans are feeling about the war, even as they

"A Veteran" <georgek@humboldt1.com> wrote in message news:georgek-800526.08512310052007@sn-ip.vsrv-sjc.supernews.net... In article <AvG0i.5436$H_.4356@newssvr21.news.prodigy.net>, "TwoBrains" <Condi republican-AlQueda@FoxNews.net> wrote: The White House session demonstrated the grave unease many Republicans are feeling about the war, even as they continue to stand with the

"A Veteran" <georgek@humboldt1.com> wrote in message news:georgek-800526.08512310052007@sn-ip.vsrv-sjc.supernews.net... In article <AvG0i.5436$H_.4356@newssvr21.news.prodigy.net>, "TwoBrains" <Condi republican-AlQueda@FoxNews.net> wrote: The White House session demonstrated the grave unease many Republicans are feeling about the war, even as they continue to stand with the