ST Alpha - "Excel question for ST:" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 155

Excel question for ST:

Posted by Beaker (aka Anniebecca) Nov 4 '09, 05:09

so I have an equation: A1+B1+C1+D1=E1
and another equation A2+B2+C2+D2=E3
E1 and E2 are supposed to equal each other but often do not.
How can I add a plug to the equation (say to B2) to make sure that E1 and E2 always equal each other?

Tried to add an addition to B2 whereby (E1-E2) is added to the calculation but that sets off the circular equation notice and can;t be done as B2 is already part of the equation.

Thanks if anyone can help.

Responses:

thanks all! -- nm - Beaker Nov 4, 06:01
Here's the formula you want in B2 - Fuzzy Nov 4, 05:42
well fileter the input so that only 1 can be added in all cells except E1 and E2 - Danedukenuuk Nov 4, 05:40
this will flag when E1 and E2 are not equal: =if(e1=e2,"","not equal") -- nm - Roger More Nov 4, 05:16 4
- so add that to the code of B2? -- nm - Beaker Nov 4, 05:31 3
  - No - how I fix these problems is to identify where the cells do not match and then looking at the data where there are errors - and I just realised - Roger More Nov 4, 05:33 1
    - what you could do is create a new column for the plug with this formula: E1-(A2+B2+C2+D2) and then - Roger More Nov 4, 05:37
  - I put my if checks like that in a new field (for example, e3 in your case) -- nm - ty97 Nov 4, 05:32
I assume in your 2nd line, you mean = E2..not E3, right? -- nm - Will Hunting Nov 4, 05:10 1
- right -- nm - Beaker Nov 4, 05:31

Post a message top

Excel question for ST:

Replies are disabled on threads older than 7 days.