View Single Post
  #6   Report Post  
 
Posts: n/a
Default

=if(c8=1,0,if(c8=2,105,IF(c8=3,390,if(c8=4,675,"") )))

-----Original 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.
.