Help with this IF statement

[murraythek]

Its currently set up as follows: =IF(B41="","","Client A Expenses: "&B41) but I want to add another cell in this case B42 to that formula to capture Client B's expenses.

How do I tie that in correctly?

 

[gaz_chops]

What exactly do you want to do with B42?

 

[mail2master]

Try to set up your table like this:

	B	C	D
40	Client Expense	Client #
41	US $ 500	Client A	=IF(B41="","",C41&" Expenses: "&B41)
42	US $ 1000	Client B	=IF(B42="","",C42&" Expenses: "&B42)

<tbody>
</tbody>

Just Drag the formula down to your range.
In case you wish to combine both the expenses in one cell, try this one: =IF(B41="","",C41&" Expenses: "&B41)&". "&IF(B42="","",C42&" Expenses: "&B42)