Microsoft Excel Multiple IFs condition, and result

[Andrian2712]

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 NAMA = BADRUN, then HARGA = 7000
if NAMA is not BADRUN, then HARGA = 8000
if NO (number) is having E on its right digit, then = 12000
if NO (number) is having C on its right digit, then = 5000


Help will be so appreciated.
Thankyou

 

[Phuoc]

Try this

=IF(C6="BADRUN",7000,IF(RIGHT(C6,1)="E",12000,IF(RIGHT(C6,1)="C",5000,IF(C6<>"",8000,""))))

 

[Andrian2712]

Try this

=IF(C6="BADRUN",7000,IF(RIGHT(C6,1)="E",12000,IF(RIGHT(C6,1)="C",5000,IF(C6<>"",8000,""))))

ohh, i just misplaced my formula, thats how if functions work, okay thankyou for your help, really appreciated. have a good day