Forum Discussion
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 ...
JasminajudoSLO You may try below formula.
=IF((C14="HB")*(M14=DATE(2022,10,27)), "YES", "NO")Remember datevalue("27.10.2022") shouldn't work as "27.10.2022" couldn't be recognized as date value. In Excel dot (.) is not date separator until you manually change date separator from control panel. DATEVALUE("27-Oct-2022") should work in this way.
=IF((C14="HB")*(M14=DATEVALUE("27-Oct-2022")), "YES", "NO")