Formula problems

[sunnydazy]

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

 

[Rick Rothstein \(MVP - VB\)]

Make sure E1 is not formatted as Text... if there is an actual number in E1,
the formula will work.

Rick

 

[Dave Miller]

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

 

[ShaneDevenshire]

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))

 

[Mike H]

It wasn't that difficult to track down!!

http://www.microsoft.com/office/com...2309&cid=b25528a3-2b34-462e-b480-7454f7626c94