One way:

=CHOOSE(C8,0,105,390,675)

If the value may be outside the range of 1-4:

=IF(AND(C8=1,C8<=4),CHOOSE(C8,0,105,390,675),"")



In article ,
A Ford <A wrote:

I need a formula that says "If the value in cell C8 is 1, then return $0. If
the value in cell C8 is 2, then return $105. If the value in cell C8 is 3,
then return $390. If the value in cell C8 is 4, then return $675.