PIECEWISE FUNCTION IN EXCEL

anyone know how to do this

(a) Use excel to create table of C(t) for the period of 12 years starting at 1990.

(b) The cost of the 30 seconds ad increase to 0.5t for t greater or equal to 11. Use excel to create table of C(t) for the period of 15 years starting at 1990.


The cost in millions of dollars of a 30 second television ad during the super bowl from 1990-2001 can be approximated by the following piecewise linear function t=0 (represents 1990)

C(T){0.08t + 0.6 if 0<=t<8
{0.355t-1.6 if 8<=t<=11

Any help??

the first answer is

x f(x)
0
1 0.6
2 0.68
3 0.76
4 0.84
5 0.92
6 1
7 1.08
8 1.16
9 1.24
10 1.595
11 1.95
2.305


the equation in excel is =IF(A2<8,0.008*A1+0.6,0.355*a2-1.6

Use embeded If statements like this

=IF(t>11,0.5*t,IF(t<=8,0.08*t+0.06,0.355*t-1.6))

thanks man appreciate it alot