IF results are one of multiple values

[Nanaia]

The following formula is resulting in a #VALUE! error indicating I've done something wrong. I want Excel to done one thing if the RIGHT is A, E, G, or K, and do something different if the result is C or H. And leave the cell blank if D12 does not contain 3000. Can anyone help me correct the formula? An example of the data in C49 would be CC12-S-A.

=IF(D12=3000,IF(RIGHT(C49,1)=OR("A","E","G","K"),ROUNDUP(E12/18,0)*2,IF(RIGHT(C49,1)=OR("C","H"),ROUNDUP(E12/18,0),"")))

 

[Fluff]

How about

=IF(D12=3000,IF(OR(RIGHT(C49,1)={"A","E","G","K"}),ROUNDUP(E12/18,0)*2,IF(OR(RIGHT(C49,1)={"C","H"}),ROUNDUP(E12/18,0),"")),"")

 

[SQUIDD]

MAYBE


=IF(D12<>3000,"",IF(OR(RIGHT(C49,1)="A",RIGHT(C49,1)="E",RIGHT(C49,1)="G",RIGHT(C49,1)="K"),"I AM A E G OR K",IF(OR(RIGHT(C49,1)="C",RIGHT(C49,1)="H"),"I AM C OR H","")))

add what you wan to happen where th text is

 

[JEC]

Maybe like this

=IF(D12=3000,ROUNDUP(E12/18,0)*IF(MAX(--(RIGHT(C49,1)={"A","E","G","K"})),2,IF(MAX(--(RIGHT(C49,1)={"C","H"})),1)),"")

 

[Eric W]

Another variation:

=IF(D12=3000,IFERROR(ROUNDUP(E12/18,0)*IF(SEARCH(RIGHT(C49),"AEGKCH")<5,2,1),""),"")