ExcelBanter - IF function Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF function Help (https://www.excelbanter.com/excel-discussion-misc-queries/243461-if-function-help.html)

IF function Help

Hello

Please Help me. I want to use the if function to pick up

For example

A B C
1 30/12/2010
2 01/07/2010 01/12/2010 01/03/2011

My current formula is the follow
=IF(A1<B2,A2,B2)

My problem lay here, I can pick up in Column A and B however if my Date in
A1 = 01/03/2011, I want the if function to pick up C2 instead of B2

IF function Help

Try this.

=IF(A1="","",IF(A1=DATE(2011,3,1),C2,IF(A1<B2,A2,B 2)))

If this post helps, Click Yes!

--------------------
(MS-Exl-Learner)
--------------------

"Harn88" wrote:

Hello

Please Help me. I want to use the if function to pick up

For example

A B C
1 30/12/2010
2 01/07/2010 01/12/2010 01/03/2011

My current formula is the follow
=IF(A1<B2,A2,B2)

My problem lay here, I can pick up in Column A and B however if my Date in
A1 = 01/03/2011, I want the if function to pick up C2 instead of B2