OR options in IF statement

S

Skeeterj

I'm trying to look at two cells, and if either has a date in it I want that
date in a third cell (where the formula is).

This formula works: =IF(COUNT(tab!$AF6)=1,MAX(tab!$AF6),"")

for checking one cell, but I also want to check (tab!AQ6) for a date. Any
suggestions?

Thanks.
 
N

Nigel

In general you can have multiple logical tests in an IF statement

=IF(AND(test1,test2),action if true,action if false)

=IF(AND(COUNT(tab!$AF6)=1,tab!AQ6 = Today()),MAX(tab!$AF6,"")

However your test if AF6 = 1, is true then MAX of it will also be 1 !
 

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

Fix Code: Select Case and "Contains" selection 5
Formula problem 5
IF FUNCTION Limitations question 3
does the =COUNTIF have to be a range? 2
IF statement with formula 2
Referencing a fixed cell in VBA using an IF statement 8
comparing text in if statement 1
formating a cell with a conditional if statement 1

Top