Forum Discussion

BenjoBenjo's avatar
BenjoBenjo
Copper Contributor
Oct 25, 2023
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 ...
excel
  • SanthoshKunder's avatar
    SanthoshKunder
    Oct 26, 2023

    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's avatar
SanthoshKunder
Iron Contributor
Oct 26, 2023

BenjoBenjo Can you please attach a sample workbook with your data( please mask your confidential data with some random texts)

Resources