| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF NOT THEN
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 ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF NOT THEN
Here's an example: =IF(A1=2,B1,C1)
Dave -- Brevity is the soul of wit. " wrote: 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 ? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF NOT THEN
=if( test when cell does not apply, default, formula)
Steve On Wed, 31 Jan 2007 16:30:02 -0000, wrote: 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 ? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF NOT THEN
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" wrote: Here's an example: =IF(A1=2,B1,C1) Dave -- Brevity is the soul of wit. " wrote: 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 ? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF NOT THEN
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 -- Brevity is the soul of wit. " wrote: 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" wrote: Here's an example: =IF(A1=2,B1,C1) Dave -- Brevity is the soul of wit. " wrote: 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 ? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF NOT THEN
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 "Dave F" wrote: 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 -- Brevity is the soul of wit. " wrote: 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" wrote: Here's an example: =IF(A1=2,B1,C1) Dave -- Brevity is the soul of wit. " wrote: 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 ? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF NOT THEN
=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 On Wed, 31 Jan 2007 08:30:02 -0800, wrote: 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 ? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF NOT THEN
Perhaps =IF(ISNUMBER(A1),A1+B1,"")
-- Brevity is the soul of wit. " wrote: 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 "Dave F" wrote: 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 -- Brevity is the soul of wit. " wrote: 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" wrote: Here's an example: =IF(A1=2,B1,C1) Dave -- Brevity is the soul of wit. " wrote: 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 ? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF NOT THEN
=IF(A1="a",B1,C1)
-- David Biddulph " wrote in message ... 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 "Dave F" wrote: 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.... " wrote: 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" wrote: Here's an example: =IF(A1=2,B1,C1) " wrote: 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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
