Perform calculation if certain number in cell; otherwise, enter value from different cell

[mcdcpa]

Hi, all. I think what I need is pretty straightforward, but I'm nonetheless struggling to achieve it. I've got three columns of data. Column A shows age in days, Column B shows a status code (1, 2, 3, 4, or 5), Column C shows days in status, and Column D will show the results of the calculation. I need a formula that will subtract Column C from Column A if Column B = 5; otherwise, the value in Column C will be returned. I'm guessing an IF statement will accomplish this, but I'm having trouble coding the piece that would return the value in Column C if the status code is 1, 2, 3, or 4.

Thanks in advance.

 

[kevin9999]

How about

=IF(B2=5,A2-C2,C2)