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