One cell to choose between two cells

[Ajb311]

I run a restaurant and need some Excel help. I have a sheet and on that sheet are four columns.
Column 1- tips earned
Column 2- tips earned with a food runner
Column 3- name of food runner/ runners that worked(if they worked)
Column 4- amount of check written to servers

We write checks at night based on either column 1 or column 2 numbers depending on if a food runner worked that night.

I don't want to manually enter what we wrote the check for. So what I was wondering is, if there was a way that when I input a name, I.E.- Jose in column three, it will automatically take the number from column 2. And if we had no food runner that night it and no name is entered it would automatically pull the number from column 1. Thank you for any insight you can give me on this.

 

[Ajb311]

Yes, check all of column 3 for a name.

 

[dreid1011]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Tips
[/TD]
[TD]Tips with Runner
[/TD]
[TD]Name
[/TD]
[TD]Check
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]100
[/TD]
[TD][/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Benny
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Try this in col 4. =IF(COUNTA(C2:C10),B2,A2)

I'm having a hard time visualizing what you have, so I hope this gets you closer to your end goal. The range C2:C10 should be adjusted to the used range of column 3 excluding the header.

I should note that this formula would only need to be put in the first cell in column 4. If there are multiple entries in columns 1 and 2, then it will need some adjusting.