The IF formula is really long, maybe the criteria are too long, but actually you can replace the long IF formula with VLOOKUP, INDEX, or CHOOSE rumus if panjang pengganti rumus if panjang