ExcelBanter - Another If Formula Question

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

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

- - Another If Formula Question (https://www.excelbanter.com/excel-discussion-misc-queries/216326-another-if-formula-question.html)

loomie

Another If Formula Question

Okay the if formula below that was given works great thanks!

With dates in a1 & B1 try this

=IF(A1=B1,"Overdue","")

However,if the date is blank it also returns false. How do I exclude blank
or make blank also overdue?

T. Valko

Another If Formula Question

Try this:

=IF(OR(A1="",A1=B1),"Overdue","")

--
Biff
Microsoft Excel MVP

"loomie" wrote in message
...
Okay the if formula below that was given works great thanks!

With dates in a1 & B1 try this

=IF(A1=B1,"Overdue","")

However,if the date is blank it also returns false. How do I exclude blank
or make blank also overdue?

Mike H

Another If Formula Question

Hi,

It's customary to feedback and ask additional questions in the same thread.
Try this

=IF(COUNT(A1:B1)<2,"",IF(A1=B1,"Overdue",""))

Mike

"loomie" wrote:

Okay the if formula below that was given works great thanks!

With dates in a1 & B1 try this

=IF(A1=B1,"Overdue","")

However,if the date is blank it also returns false. How do I exclude blank
or make blank also overdue?

All times are GMT +1. The time now is 08:40 AM.