| Home |
| Search |
| Today's Posts |
|
#7
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 ? |
Threaded Mode
