Hello all,
I would like to write a formula that Excel would calculate only if a condition in a cell is meet otherwise return blank field. For my attached example, I want Excel to calculate = (MKT - PMKT)/PMKT only if DateRange is "InRange" else return a blank space. Thank you for your help in advance.
Capture.PNG
Bookmarks