- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Need Help with an Excel Formula
Posted on 12/15/14 at 9:51 pm to northern
Posted on 12/15/14 at 9:51 pm to northern
Are you limited in columns you could use? Do you want the same result if "+" and same if "-"?
If so, build a hidden column next to A/B and Y/Z, and use a singe IF to assign the value of X as "1" and Y as "-1", same for A/B. Then just use IF that Column A/B x Column Y/Z is positive/negative.
If so, build a hidden column next to A/B and Y/Z, and use a singe IF to assign the value of X as "1" and Y as "-1", same for A/B. Then just use IF that Column A/B x Column Y/Z is positive/negative.
Popular
Back to top
Follow TigerDroppings for LSU Football News