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

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

Formula problems
 

=IF(E1=1,SUM(J1,J5),IF(E1=2,SUM(J1,J6),0))

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

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