[Solved] How to set column conditionally in Excel?

by


If you want the name in column E and the worked hours in column F then set E1 to 

=IF(B1>0,A1,"")

and set F1 to

=IF(B1>0,B1,"")

If you want the name and worked hours both in column E then set E1 to

=IF(B1>0,CONCATENATE(A1," ",B1),"")

and copy down the column.

IF(condition, expression if true, expression if false) allows you to set cells based on a logical condition. CONCATENATE allows you to join the contents of multiple cells (or expressions) together as a string.

1

solved How to set column conditionally in Excel?