IF function Help

H

Harn88

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
 
M

Ms-Exl-Learner

Try this.

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

If this post helps, Click Yes!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check if a date comes before/after a range of dates 0
Dcount -Date Criteria - Won´t find it - 0
Find then highlight in yellow 6
Return a value when Date x is between Date y and z 4
Count specific days in between dates 2
SUMIF Formula Help 8
Macro to goto specific cell (todays date) 4
Specific Date from a Range 3

Top