| 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. |
| 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) | |||
Threaded Mode
