Solved

# IF(OR) Statement

Posted on 2014-08-13
113 Views
Hi,

I have an IF(OR) below

The formula result is "No" but the date serials match, so B17 is today()

Its checking date stamps dropped into the other spreadsheets by VB using =now()

Cutting the dates using left returns 41864 for all the cells in the IF and today()

Why am getting "No" returned?

Thanks

=IF(OR(LEFT('[NA.xlsm]PB Review'!\$H\$1,5)=B17,LEFT('[Europe.xlsm]PB Review'!\$H\$1,5)=B17,(LEFT('[MENA.xlsm]PB Review'!\$H\$1,5)=B17),(LEFT('[Asia.xlsm]PB Review'!\$H\$1,5)=B17),(LEFT('[LATAM.xlsm]PB Review'!\$H\$1,5)=B17)),"Yes","No")
0
Question by:Seamus2626

LVL 47

Accepted Solution

Hi,

If you want to compare Today() and Now() you have to INT(Now()) = Today()

=IF(OR(INT('[NA.xlsm]PB Review'!\$H\$1)=B17,INT('[Europe.xlsm]PB Review'!\$H\$1)=B17,INT('[MENA.xlsm]PB Review'!\$H\$1)=B17,INT('[Asia.xlsm]PB Review'!\$H\$1)=B17,INT('[LATAM.xlsm]PB Review'!\$H\$1)=B17),"Yes","No")

Regards
0

Author Closing Comment

Legend!
0

## Featured Post

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.