Hello, im having a problem with my formula, i wanted multiple condition, and multiple result, here is what i got for now.
Formula : =IF(C6="BADRUN",7000,IF(C6<>"BADRUN",8000,IF(RIGHT(C6,1)="E",12000,IF(RIGHT(C6,1)="C",5000))))
im putting this formula at "KILOAN" - "HARGA"
My condition,
if...