Seamus2626
asked on
IF(OR) Statement
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.xl sm]PB Review'!$H$1,5)=B17,(LEFT( '[MENA.xls m]PB Review'!$H$1,5)=B17),(LEFT ('[Asia.xl sm]PB Review'!$H$1,5)=B17),(LEFT ('[LATAM.x lsm]PB Review'!$H$1,5)=B17)),"Yes ","No")
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('
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER