Forum Discussion

ROBHE640's avatar
ROBHE640
Copper Contributor
Aug 02, 2021

3 different arguments with =IF

Hey, I need to create a formula with three different arguments, the only relation is if the other ones do not apply, I create an example that is not working.

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    ROBHE640 What are you trying to achieve with the second IF? You formula reads contains IF(O(B6.......

     

    What is the "O" for? Do you perhaps intend to use an OR statement or did you just type it accidentally? Anyway, "O" is not a valid Excel function.

Resources