Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF((F6="C06"&G6="A"),E6,0) both F6 and G6 are true
I am creating a spread sheet and I need to add colums together based on two
different inputs. the "IF statement" seems to to work fine with only one condition such as: =if(F6="C06",E6,0) + if(F7="C06",E7,0) This statement will add E6 to E7 if the F cell is true and it works, How do I check the condition of two cells. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF((F6="C06"&G6="A"),E6,0) both F6 and G6 are true
please elaborate...is it something like...
=IF(AND(F6="C06",F7="C06"),(E6+E7),0) not sure.. "J_Swoll" wrote in message ... I am creating a spread sheet and I need to add colums together based on two different inputs. the "IF statement" seems to to work fine with only one condition such as: =if(F6="C06",E6,0) + if(F7="C06",E7,0) This statement will add E6 to E7 if the F cell is true and it works, How do I check the condition of two cells. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF((F6="C06"&G6="A"),E6,0) both F6 and G6 are true
Please remember to include the details of your question in the body of the
text, as readers may well not notice what you've hidden in the subject line. =if(AND(F6="C06",G6="A"),E6,0) + if(F7="C06",E7,0) -- David Biddulph "J_Swoll" wrote in message ... I am creating a spread sheet and I need to add colums together based on two different inputs. the "IF statement" seems to to work fine with only one condition such as: =if(F6="C06",E6,0) + if(F7="C06",E7,0) This statement will add E6 to E7 if the F cell is true and it works, How do I check the condition of two cells. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF((F6="C06"&G6="A"),E6,0) both F6 and G6 are true
=SUMIF(F6:F7,"C06",E6:E7)
"J_Swoll" wrote: I am creating a spread sheet and I need to add colums together based on two different inputs. the "IF statement" seems to to work fine with only one condition such as: =if(F6="C06",E6,0) + if(F7="C06",E7,0) This statement will add E6 to E7 if the F cell is true and it works, How do I check the condition of two cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please Help Me with Custom menus | Excel Worksheet Functions | |||
Stop renaming or moving sheet tabs | Excel Discussion (Misc queries) | |||
Linked Check Boxes | Excel Discussion (Misc queries) | |||
Disable CUT via toolbars or shortcut keys | Excel Discussion (Misc queries) | |||
Disable "Cut" only | Excel Discussion (Misc queries) |