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