Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create an "IF" formula?
something like this?
=if(and(a1="vac",b5="pho"),sum(a2:a5),"") -- Don Guillett SalesAid Software "Mary" <Mary @discussions.microsoft.com wrote in message ... I am looking for imformation on doind "IF" formulas. Ex: If A1 is VAC and B5 is PHO then it totals. They are called if formulas? Any instructions would be good. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How to create a scatter chart with 2 "X" values with common "Y"s | Charts and Charting in Excel | |||
cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions |