Creating a graph simulating severel values for “X”.

Hello, I am using Excel 2007 and having difficulty creating a graph that calculates the value “y” for several “x” values.

Here is the thing, I am making a simple, yet complex spreadsheet in Excel, this is the cell we’ll be focusing on:

=IF(G2=0;((IF(G2=0;INT(I2/F2);INT((I2-F2)/G2)+1))*H2)*E2;(((IF(G2=0;INT(I2/F2);INT((I2-F2)/G2)+1))*H2)*D2)-C2)

The cell above needs to be the value for “y” while the cell “I2” (used in the formula more than once) needs to be the value for “x”. The thing is, I want to create a line graph that shows the value for “y” when “x” equals 28, 56, 112, 224, 448 and so on, without actually changing I2’s cell value, since it is also a function as long as the one above.

I would really appreciate if anyone could help me on this, thanks in advance!

By: Bruno

Leave a Reply

Your email address will not be published. Required fields are marked *