Thread: excel piecewise functions

hey is there any way of making a piecewise function on excel without the use of 3rd party products?
i want to add two linear trend line to different parts of my data

Originally Posted by luysion

hey is there any way of making a piecewise function on excel without the use of 3rd party products?
i want to add two linear trend line to different parts of my data

See if this google hit helps, scroll a couple of pages down:

http://faculty.mc3.edu/whunter/excel...0FUNCTIONS.doc

Originally Posted by luysion

hey is there any way of making a piecewise function on excel without the use of 3rd party products?
i want to add two linear trend line to different parts of my data

Check out the IF function.

For example, if you want


otherwise,

and x is in cell A1, then the function would be

=IF(A1<3, 2*A1+3, 3*A1-8)