if inside if

  1. T

    Embedded Index and Match and If statements

    {=IFERROR(VLOOKUP(IF(COUNTIF(Table1,INDEX(Table1[User ID], MATCH("Yes", IF(Table1[Asset]=Sheet2!$C8,Sheet1!L$2:L$343),0)))>1, "Double", INDEX(Table1[User ID], MATCH("Yes", IF(Table1[Asset]=Sheet2!$C8,Sheet1!L$2:L$343),0))),Table1,7,FALSE)&") "&(IF(COUNTIF(Table1,INDEX(Table1[User ID]...
  2. T

    IF statements

    I was using an If statement, thought it was set up correctly but as I've been entering data it hasn't represented data like i wanted it to. It represents a grade scale for my classes where D7 is my final percentage...

Some videos you may like

This Week's Hot Topics