Forum Discussion
JasminajudoSLO
Aug 30, 2022Copper Contributor
EXCEL IF....
Hi everyone, I would need help, I'm new in IF function, so I would be happy of your help. How should I write IF fomula IF for: I have one cell C14 with word HB in it and one cell with the dates and ...
sivakumarrj
Aug 30, 2022Brass Contributor
27.10.2022 is considered as text in Excel, So simply write formula like
IF(AND(C14="HB", M14="27.10.2022"), "YES", "NO"))
Date value will not be converted to value unless it is in proper format like Month/Date/Year or Date/Month/Year setting in Excel i.e. 10/27/2022 or 27/10/2022
https://support.microsoft.com/en-us/office/datevalue-function-df8b07d4-7761-4a93-bc33-b7471bbff252
IF(AND(C14="HB", M14="27.10.2022"), "YES", "NO"))
Date value will not be converted to value unless it is in proper format like Month/Date/Year or Date/Month/Year setting in Excel i.e. 10/27/2022 or 27/10/2022
https://support.microsoft.com/en-us/office/datevalue-function-df8b07d4-7761-4a93-bc33-b7471bbff252