| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Speedy way to create IF Function
Greetings, I am hoping someone knows a trick for completing a LONG if
statement. Here is my statement getting info from 2 fields... =(IF(B41=Direct!E8,Direct!F8,0)+(IF(B41=Direct!E9, Direct!F9,0))) I actually need this function to grab figures from E9/F9 through E250/F250, maybe even more. As you can guess I don't want to manually type that out. Any suggestions on a process that might speed up the process? The purpose of this statement is to get a total dollar amount spent for a catagory. The Bxx field is a catagory, the Direct!Exx field is a compared Catagory, and the Direct!Fxx field is a dollar amount. Any assistance is greatly appreciated -John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a function to search a range for a number and... | Excel Worksheet Functions | |||
| Create a function between sheets | Excel Discussion (Misc queries) | |||
| Create a function wher last digit is always set | Excel Worksheet Functions | |||
| Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
| Using CONCATENATE function to create email addresses from a list | Excel Worksheet Functions | |||
Threaded Mode
