Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula problems
Hello;
I sent in a question this morning but it seems to have disappeared. it is an if and then situation. this was the first response, but it didn't work. =IF(E1=1,J1+J5,IF(E1=2,J1+J6,"")) if cell E1=1 then add cell J1 to cell J5 if cell E1=2 then add cell J1 to cell J6 thank you for your help, Sunnydazy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula problems
Make sure E1 is not formatted as Text... if there is an actual number in E1,
the formula will work. Rick "sunnydazy" wrote in message ... Hello; I sent in a question this morning but it seems to have disappeared. it is an if and then situation. this was the first response, but it didn't work. =IF(E1=1,J1+J5,IF(E1=2,J1+J6,"")) if cell E1=1 then add cell J1 to cell J5 if cell E1=2 then add cell J1 to cell J6 thank you for your help, Sunnydazy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula problems
=IF(E1=1,SUM(J1,J5),IF(E1=2,SUM(J1,J6),0))
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula problems
Hi,
As stated this is the correct solution: =IF(E1=1,J1+J5,IF(E1=2,J1+J6,"")) So if its not working your description of the problem is incomplete, my guess is you want to add 0 to J1 if E1 does not equal 1 or 2, if so then =J1+IF(E1=1,J5,IF(E1=2,J6,0)) -- Cheers, Shane Devenshire "sunnydazy" wrote: Hello; I sent in a question this morning but it seems to have disappeared. it is an if and then situation. this was the first response, but it didn't work. =IF(E1=1,J1+J5,IF(E1=2,J1+J6,"")) if cell E1=1 then add cell J1 to cell J5 if cell E1=2 then add cell J1 to cell J6 thank you for your help, Sunnydazy |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula problems
It wasn't that difficult to track down!!
http://www.microsoft.com/office/comm...0-7454f7626c94 "sunnydazy" wrote: Hello; I sent in a question this morning but it seems to have disappeared. it is an if and then situation. this was the first response, but it didn't work. =IF(E1=1,J1+J5,IF(E1=2,J1+J6,"")) if cell E1=1 then add cell J1 to cell J5 if cell E1=2 then add cell J1 to cell J6 thank you for your help, Sunnydazy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problems | Excel Discussion (Misc queries) | |||
aauugghhh...#div/o problems & various average formula problems | Excel Worksheet Functions | |||
If formula problems | Excel Discussion (Misc queries) | |||
Formula Problems | Excel Discussion (Misc queries) | |||
Formula Problems | Excel Worksheet Functions |