| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
State Tax Business Calculations Help
Urgg.. I've been trying to figure out this one for days and it's eating my lunch.. What I need F20 to do is this:
If B2:B10 does not contain the abbreviation "OK" And H2:H10 does not have a dollar amount in it then add the total of G2:G10 (B2:B10,"<ok",H2:H10,"=0",G2:G10) attached is my excel spreadsheet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace state names with state code abbreviations | Excel Worksheet Functions | |||
| Calculating 10 Business Days from the Last Business Day of the Mon | Excel Worksheet Functions | |||
| How can I show state-by-state data (as silos) on a map of NA | Charts and Charting in Excel | |||
| Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
| WHERE CAN I GET A BUSINESS PROPOSAL OR A BUSINESS EXPENSE SHEET? | New Users to Excel | |||
Threaded Mode
