Formula problems

  • Thread starter Thread starter sunnydazy
  • Start date Start date
S

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
 
Make sure E1 is not formatted as Text... if there is an actual number in E1,
the formula will work.

Rick
 
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))
 
Back
Top