RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Please help me to solve this if function.
Cell A contains <TALLYMESSAGE xmlns:UDF="TallyUDF"><VOUCHER><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST>
Cell B contains TEXT('Sheet1'!A2,"yyyymmdd") from another sheet
If cell B=19000100, show blank, else show <TALLYMESSAGE xmlns:UDF="TallyUDF"><VOUCHER><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST>
B column contains different text value of date in yyyymmdd format. 20200401, 20200402,etc, The cell which contains 19000100, should display a blank cell in A column.
Cell A contains <TALLYMESSAGE xmlns:UDF="TallyUDF"><VOUCHER><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST>
Cell B contains TEXT('Sheet1'!A2,"yyyymmdd") from another sheet
If cell B=19000100, show blank, else show <TALLYMESSAGE xmlns:UDF="TallyUDF"><VOUCHER><OLDAUDITENTRYIDS.LIST TYPE="Number"><OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS></OLDAUDITENTRYIDS.LIST>
B column contains different text value of date in yyyymmdd format. 20200401, 20200402,etc, The cell which contains 19000100, should display a blank cell in A column.