DashboardNovice
Member
I am trying to take a number and raise that to a negative power, but I don't want to hard code that negative power, I want to use a cell reference.
In the attached file, I am entering the S(t) function in cell Q8. To generate the number "e" I am using EXP(1), which works fine. My exponent is raised to "negative t," where the value of t is in cell P8 and down. Here is my current formula:
I am referencing cell P8 but I'm putting a negative in front of it. Somehow I don't think this looks right. Is this correct, or do I need to use " " followed by an ampersand?
I am also trying to plot an S curve, but I can't find examples of a dataset to plot a standard S curve. I would think that starting with 1 would suffice, but it doesn't seem to plot much of an S curve (if my formula is correct). I included a graphic of what I am trying to plot. I don't care about the data, I just want to plot the graph.
In the attached file, I am entering the S(t) function in cell Q8. To generate the number "e" I am using EXP(1), which works fine. My exponent is raised to "negative t," where the value of t is in cell P8 and down. Here is my current formula:
Code:
=1/(1+POWER(EXP(1),-P8))
I am referencing cell P8 but I'm putting a negative in front of it. Somehow I don't think this looks right. Is this correct, or do I need to use " " followed by an ampersand?
I am also trying to plot an S curve, but I can't find examples of a dataset to plot a standard S curve. I would think that starting with 1 would suffice, but it doesn't seem to plot much of an S curve (if my formula is correct). I included a graphic of what I am trying to plot. I don't care about the data, I just want to plot the graph.
Attachments
Last edited: