Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula problem
I have an "either or" situation:
If cell E1 is 1 then add the entry in J1 to cell J5, or If cell E1 is 2 then add the entry in J1 to cell J6 This solution was posted yesterday, but it didn't work. =IF(E1=1,J1+J5,IF(E1=2,J1+J6,"")) Any suggestions would be greatly appreciated. Thank you, Sherry |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula problem
It works for me, as expected.
It would be helpful if you told us what values where in E1, J1, J5 & J6 and what result you got. You could also use =J1+J5*(E1=1)+J6*(E1=2) but this will return the value in J1 if E1 has any value other than 1 or 2 Do tell us more, we want to help -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "sunnydazy" wrote in message ... I have an "either or" situation: If cell E1 is 1 then add the entry in J1 to cell J5, or If cell E1 is 2 then add the entry in J1 to cell J6 This solution was posted yesterday, but it didn't work. =IF(E1=1,J1+J5,IF(E1=2,J1+J6,"")) Any suggestions would be greatly appreciated. Thank you, Sherry |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula problem
The value in the E column will always be 1 or 2 The value in the J column
will be a cash value. The formula should separate the total amounts by either the first participant(1) or the second(2). I keep getting the error message on the formula. Thanks for contacting me. Sherry "Bernard Liengme" wrote: It works for me, as expected. It would be helpful if you told us what values where in E1, J1, J5 & J6 and what result you got. You could also use =J1+J5*(E1=1)+J6*(E1=2) but this will return the value in J1 if E1 has any value other than 1 or 2 Do tell us more, we want to help -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "sunnydazy" wrote in message ... I have an "either or" situation: If cell E1 is 1 then add the entry in J1 to cell J5, or If cell E1 is 2 then add the entry in J1 to cell J6 This solution was posted yesterday, but it didn't work. =IF(E1=1,J1+J5,IF(E1=2,J1+J6,"")) Any suggestions would be greatly appreciated. Thank you, Sherry |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula problem
I don't want to seem like a dimwit but I can't get the formula to work. Excel
is an Office program I don't have much experience with. Which cell did you enter the formula into and exactly what was needed to amend it for that particular cell? I have been puting it into the E cell and removing the circular reference information, but I still can't get it to work. Sorry to keep having to pester you, Sherry "Bernard Liengme" wrote: It works for me, as expected. It would be helpful if you told us what values where in E1, J1, J5 & J6 and what result you got. You could also use =J1+J5*(E1=1)+J6*(E1=2) but this will return the value in J1 if E1 has any value other than 1 or 2 Do tell us more, we want to help -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "sunnydazy" wrote in message ... I have an "either or" situation: If cell E1 is 1 then add the entry in J1 to cell J5, or If cell E1 is 2 then add the entry in J1 to cell J6 This solution was posted yesterday, but it didn't work. =IF(E1=1,J1+J5,IF(E1=2,J1+J6,"")) Any suggestions would be greatly appreciated. Thank you, Sherry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula problem | Excel Worksheet Functions | |||
Formula problem | Excel Worksheet Functions | |||
Formula problem | Excel Discussion (Misc queries) | |||
formula problem | Excel Discussion (Misc queries) | |||
Need a formula for this problem | Excel Worksheet Functions |