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 ...
OliverScheurich
Aug 30, 2022Gold Contributor
=IF(AND(C14="HB", M14=DATEVALUE("27.10.2022")), "YES", "NO")You can try this formula.