if both a1 & b1 are not blank, then insert a '1' into cell c1

[Trevor3007]

hello,

please can some more excel knowledge than i , send to the formula so only if cell a1 & b1 are not blank, then insert 1 into c1.

I tried to do this myself, but even when a1 or b1 is /both blank, it still puts a 1 into c1

thank you in advance

 

[Fluff]

How about

=if(and(a1<>"",b1<>""),1,"")

 

[Scott Huish]

Perhaps:
=IF(COUNTA(A1:B1)=2,1,"")

 

[Trevor3007]

Perhaps:
=IF(COUNTA(A1:B1)=2,1,"")

works great ...thank you

 

[Trevor3007]

How about

=if(and(a1<>"",b1<>""),1,"")

another winner...thank you

 

[Rick Rothstein]

I know I am late to this thread, but here is a formula I came up with...

=LEFT(1,COUNTA(A1:B1)>1)

This version would also work...

=LEFT(1,(a1<>"")*(b1<>""))

As would this version...

=LEFT(1,LEN(A1)*LEN(B1))

 

[Fluff]

Glad we could help & thanks for the feedback.