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

[TABLE="width: 241"]
<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>[TR]
[TD="class: xl63, width: 29, bgcolor: transparent"] [/TD]
[TD="class: xl64, width: 64, bgcolor: #D9D9D9"]A[/TD]
[TD="class: xl64, width: 64, bgcolor: #D9D9D9"]B[/TD]
[TD="class: xl64, width: 85, bgcolor: #D9D9D9"]C[/TD]
[TD="class: xl64, width: 78, bgcolor: #D9D9D9"]D[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9"]1[/TD]
[TD="class: xl69, width: 64, bgcolor: #B4C6E7"]Residual life[/TD]
[TD="class: xl69, width: 64, bgcolor: #B4C6E7"]Residual Life Override[/TD]
[TD="class: xl69, width: 85, bgcolor: #B4C6E7"]Confirmed residual life[/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9"]2[/TD]
[TD="class: xl63, bgcolor: transparent"]5[/TD]
[TD="class: xl63, bgcolor: transparent"]3[/TD]
[TD="class: xl70, width: 85, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: right"]3[/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9"]3[/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9"]4[/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[TD="class: xl63, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[JackDanIce]

You're welcome Ben