Directing output of if statement...

Microsoft Excel 010 - complete package
October 6, 2010 at 09:53:17
Specs: Windows 7
...I can't figure out how to create an if statement that will output the true value into another cell. Basically, I have a list of x and y values. I need a statement that will take an input row number and calculate the slope based on the surrounding values. I got that part, I just need the if statement to spit the slope out in a specified cell. I originally hoped I could just make the true value say something like, H3 = slope(blah blah), but excel didn't like it. I also considered just making the output cell say, "=whatever cell the answer lands in now" but i'm not sure that is acceptable.

See More: Directing output of if statement...

Report •

October 6, 2010 at 10:28:40
I'm a bit confused as to what you are trying to do.

An Excel formula can only produce it's output in the cell in which it resides.

If you have a formula that is working, why aren't you putting that formula in the cell where you want the answer?

Report •

October 8, 2010 at 08:30:54
Because the formula relies on relative references from the x and y values it uses, so if i put it in one cell, it'll only produce results for one x value.

Report •

October 8, 2010 at 09:31:31
Please post the formula you trying to use and give us a detailed explanation of what your goal is.

If possible, included examples of inputs and the desired outputs for those values.

Keep in mind that we can not see your spreadsheet from where we're sitting, so you have to give us all the information we need to answer your question.

If you are going to be posting columns of data, please use the pre tags found above the Reply box to help format your data.

Report •

Related Solutions

Ask Question