Hi
better to use a lookup table for this . e.g. on a separate sheet
(called 'lookup') create the following:
A B
1 1 0
2 2 105
3 3 390
....
Now use the following formula
=VLOOKUP(C8,'lookup'!A1:B10,2,0)
--
Regards
Frank Kabel
Frankfurt, Germany
"A Ford" <A
schrieb im Newsbeitrag
...
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.