Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compound IF statement
I am attempting to code a UDF for the first time. The small spreadsheet I've
set up is in sheet 1 ("Database") and just two columns relate to my question. Col 1 is populated with either "BA" or "V" and Col 2 with "AD" or "DC". If BA = DC, then I need to sum those enties into a cell on a report section on sheet 2 ("Report"). Thus, I an ignoring "V" and "AD" entries. How do I code the UDF? How do I get it into the spreadsheet? I have been reading about VBA, know I need a UDF and need a Sub routine to call the UDF. But I've never done either of those events. I am using Excel 2000. Any help at all, with either of these questions, would be so much appreciated! Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compound If, And Or - can | Excel Discussion (Misc queries) | |||
How do I write a compound if statement? | Excel Worksheet Functions | |||
compound | Excel Discussion (Misc queries) | |||
Compound interest | Excel Worksheet Functions | |||
Problem with compound IF statement | Excel Worksheet Functions |