Hello. Is there a way to have a cell input different data dependent upon the result from a choice from a preceeding pull down menu? Each client has different billing schedules, and the cell would calculate based on the formula for the specific schedule. For example, if A1 contained "DDS" rather than "Law Firm" from a pull down, is there a way to have a specific formula for each in B1? If so, how many arguments can I use? Thanks in advance for your help.
Bookmarks