Reply
Wed 30 Apr, 2003 03:50 pm
I have a table that contains a row with many numbers. I want to look at each individual cell in that column and compare its value to a range of values. If the value in the cell matches the range, I want to add a percentage to the number and store the result in another cell of another column. If the value in the cell does not match the range, I don't want to do anything.
Are you trying to do this in a program such as Excel?
It is. I gave it my feeble best shot under the "Excel question" heading, by the same creator. Maybe you can improve on it. I haven't used the =if functions extensively since lotus r2.1 was the hot tip
Ah, yes, I saw that.
This seems to be an if/then type of question. E. g. if the # in the cel matches the range, then ___. If the # in the cel doesn't match the range, then __(other thing).
Try this:
=IF(C1=A1:A5,C1+0.05)
This puts the cel where you want the operation to occur in the C column, and the test range in the A column (A1 through A5). The 0.05 is just something to add; you'd change that to whatever % you want. It returns the word "False" if the condition isn't met. Just tried it in Excel 95 and it works.
Stumble It!
Tweet This
Bookmark on Delicious
Share on Facebook
Share on MySpace