# PIECEWISE FUNCTION IN EXCEL

• Sep 19th 2005, 11:15 AM
suckatmath
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??
• Sep 19th 2005, 11:21 AM
suckatmath

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
• Sep 19th 2005, 03:14 PM
MathGuru
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))
• Sep 19th 2005, 03:22 PM
suckatmath
thanks man appreciate it alot