Forum Discussion
Solved
IF AND OR
Hi everyone, Could someone pls help me on using IF AND OR functions. I wanted do a kinda XLoopup but more of a IF with multiple criteria. I have a leave taken and ended in a sheet called COMP Leave ...
BenjoBenjo - Not sure why it's not working for you. I copied your final formula and it works for me.
Regarding --, we must use --. It's simple. First hyphen(-) negates the TRUE and the second hyphen reverse the negation(Negative multiplied by Negative is a positive number).
SanthoshKunder This is awesome!!! But I want to refer to the table named "COMP_Leave" from different sheet. My date range is not static and will change when i refresh. SO I am looking forward to reference table instead of static dates. Thanks