I'm trying to write a formula to determine what goes into a particular cell.
There is a date in cell A4. If Date in cell B4 is newer than the date in A4, then the value in cell D4 should be "". If date in cell B4 is older or equal to the date in A4 then the value should either be "4" if C4 = "LM" or "8" if C4 = "HM". Can anybody tell me how to write this formula as I keep getting an error. Thank you