One way

=VLOOKUP(C8,{1,0;2,105;3,390;4,675},2,0)

Regards,

Peo Sjoblom

"A Ford" 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.