• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel Help

P

PRLJAMN

Junior Member
Need a little help in Excel concerning IF, THEN statements...

Suppose I have two columns, Column A and Column B; both were formed by calculations (in it, they contain formulas to achieve what's in the cell right now).

So lets say that in Column A, I have a calculation; it can be any number. For Column B, I want to display a certain number that is directly from Column A (for instance, if Column A shows any number from "0" to "4", then I want Column B to be a "0". This is of course, after the original calculations have been made, so in a sense, it's like Excel would make a calculation, then check the other column, and then go through with the next formula.

Going further, if Column A displayed a number from "5 to 9", then Column B should automatically show "1".

REMEMBER, both columns have already been formed by a previous calculation, I just simply want to add a "layer" upon each. I know you would use the IF formula, but I've tried nearly everything, and thus, need to take my problems to ATOT...

Thanks!
 
I simply want to take what is in Column A, whatever the number, and display it (according to the formula) as a different number in Column B.

For instance, if Column A shows "2", then I want Column B to automatically display a "0".

But, this is after both columns are made by previous calculations.
 
Forum Nazi alert., Forum Nazi alert.

Not that I give a rat's ass, but this really is the wrong forum. There is a Software Forum where people who are experts with software hang out just itching to help peeps like you with your software problems. If everybody posted their software problems in ATOT the Admins would have to close down the software forum and OT would become a cesspool of people asking irrevelant questions like, "When will my nads drop?"

😉
 
so you want column b to display the first set of values, then after some event display the second set? i'm not sure if you can do that without scripting. can't you just use another column?

so does column A's value depend on column B?
 
Originally posted by: PRLJAMN
I simply want to take what is in Column A, whatever the number, and display it (according to the formula) as a different number in Column B.

For instance, if Column A shows "2", then I want Column B to automatically display a "0".

But, this is after both columns are made by previous calculations.
Click to expand...
Doing that would cause circular reference errors. You need an additional column.
 
Yeah I kept getting circular reference messages. So I just need to create a new column and implement everything from Column A and B as far as the IF statements? Or is there an easier way? Thanks minendo.

Sorry for wasting your time HappyPuppy, you must be exhausted after writing all that...take a break, a couple of Tylenol. 😉
 
Originally posted by: PRLJAMN
Yeah I kept getting circular reference messages. So I just need to create a new column and implement everything from Column A and B as far as the IF statements? Or is there an easier way? Thanks minendo.

Sorry for wasting your time HappyPuppy, you must be exhausted after writing all that...take a break, a couple of Tylenol. 😉
Click to expand...

Create a table (at the top of the worksheet out of the way of all other info) of lookup values and use the vlookup or hlookup function in column C.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top