IF NOT THEN

[clemente821]

How can I have a formula include data when applicable and at the same time
when that cell does not apply to have it default to another cell to calculate
a sum ?

 

[Dave F]

Here's an example: =IF(A1=2,B1,C1)

Dave

 

[SteveW]

=if( test when cell does not apply, default, formula)

Steve

 

[clemente821]

Dave Thanks, One more thing Now I need the opposite if A1 has a value How do
I write the logic for that.

 

[Dave F]

I'm not sure what you mean by "the opposite". The formula I gave in my
earlier response tests to see if A1 has a value....

Dave

 

[clemente821]

Dave, If A1 has a and that value needs to be added to create a sum how do I
creat that. Sorry for not being clear

 

[Gord Dibben]

=IF(A1=10,A1+B1,C1+B1)

If A1 equals 10 then add A1 and B1

If A1 not equal to 10 then add C1 and B1


Gord Dibben MS Excel MVP

 

[Dave F]

Perhaps =IF(ISNUMBER(A1),A1+B1,"")

 

[David Biddulph]

=IF(A1="a",B1,C1)
--
David Biddulph

Dave, If A1 has a and that value needs to be added to create a sum how do
I
creat that. Sorry for not being clear