# Thread: PIECEWISE FUNCTION IN EXCEL

1. ## PIECEWISE FUNCTION IN EXCEL!!!!!!! (im stupid)

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??

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

3. ## Embedded if then statements excel

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))

4. thanks man appreciate it alot

,

,

### piece function

Click on a term to search for related topics.