Hi,
I have a formula =IF(OR('Accrual Template'!E12="Select Accrual Category",'Accrual Template'!E12=""),"",EOMONTH(DATE('Accrual Template'!$D$4,MONTH(DATEVALUE('Accrual Template'!$D$3&"1")),1),0))
the point is that if in the accrual template the E12 is empty or "Select Accrual Category", it would return "" blank result, if False it would return a date. Odd thing is that in mu excel it works without issue. But one of the users got #VALUE! error. I evaluated the formula and only #N/A error is with the TRUE returning "". In my excel if I just press Enter in the formula bar it shows the correct result. Do not understand what is the problem in the user's excel.
Please help.
I have a formula =IF(OR('Accrual Template'!E12="Select Accrual Category",'Accrual Template'!E12=""),"",EOMONTH(DATE('Accrual Template'!$D$4,MONTH(DATEVALUE('Accrual Template'!$D$3&"1")),1),0))
the point is that if in the accrual template the E12 is empty or "Select Accrual Category", it would return "" blank result, if False it would return a date. Odd thing is that in mu excel it works without issue. But one of the users got #VALUE! error. I evaluated the formula and only #N/A error is with the TRUE returning "". In my excel if I just press Enter in the formula bar it shows the correct result. Do not understand what is the problem in the user's excel.
Please help.