Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

If Range of Cells Are Populated Insert "1" In Cell 1

Status
Not open for further replies.
akrshaw

akrshaw

Programmer
Oct 24, 2006
77
US

There is probably a VERY simple solution to this but I cannot figure it out.

I have this scenario

Bid MGR Bid CRD Both
Jane John 1
Jane
John
Jane John 1

I would like for the Both Cell to look at the other 2 cells and automatically put a 1 in it?

Thanks :)
 
Sort by date Sort by votes
Many ways to do this, but you can try:

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

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

N1GHTEYES
  • Locked
  • Question
Count range overlap cells
Replies
3
Views
498
N1GHTEYES
N1GHTEYES
bkoopers
  • Locked
  • Question
Problem with Excel pasting into filtered cells
Replies
1
Views
238
combo
combo
D
  • Question
How can i have more than 1 line in the body of an email
Replies
2
Views
257
Andrzejek
Andrzejek
N1GHTEYES
  • Locked
  • Question
Count areas within a range 1
Replies
14
Views
1K
SkipVought
S
TrekBiker
  • Locked
  • Question
Use 2 columns in Detail Section of report 1
Replies
8
Views
619
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top