Hi
=IF(C8=1,0,IF(C8=2,105,IF(C8=3,390,IF(C8=4,675,"so mething else"))))
change the "something else" to whatever you want if C8 doesn't fall between
1 & 4 inclusive
OR
=CHOOSE(C8,0,105,390,675)
note, this will return #value if C8 doesn't fall between 1 & 4 inclusive
Cheers
JulieD
"A Ford" <A
wrote in message
...
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.