The long IF formula replace with Vlookup, Index, or Choose
The formula if it's really long, maybe the criteria are a lot of long, but actually you can replace the long IF formula with vlookup, index, or choose
rumus if panjangpengganti rumus if panjang