Simple IF Statement

[EvansB2]

Hi there,

In cell C2 (green) I have the following basic formula =IF(C2<B2,C2,B2). I would like to add another argument that if no entry is put in cell B2, then cell A2 is returned instead of "0".

Any assistance would be greatly recieved.

Regards

Ben

	A	B	C	D
1	Residual life	Residual Life Override	Confirmed residual life
2	5	3	3
3
4

<colgroup><col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1060;"> <col width="64" style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" span="2"> <col width="85" style="width: 64pt; mso-width-source: userset; mso-width-alt: 3108;"> <col width="78" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;"> <tbody> </tbody>

 

[JackDanIce]

You're welcome Ben