> =IF(C16="State Funds";135;0) > > The determining factor is really simple, in all cases where the text in > say C16 contains State H16 = 135 otherwise H16 = 0. The determining > field could contain just State Funds which is the majority of the time, > or can also contain State Funds/Peachcare or State Funds/Wellcare. What > is the proper way in the formula to tell calc that if the C16 contains > State, and the above variations mentioned that H16 should be 135, > otherwise put 0 into that cell.
The answer to your first question is this: =IF(C16="State Funds/Peachcare";135;IF(C16="State Funds/Wellcare";135;0)) For each permutation of "State Funds", you need to have a nested IF statement. I do not know if OpenOffice Calc has a hard limit on the number of nested IF statements allowed; Excel will only allow you to go to 7 levels of Nested Ifs. If you need more than nested IFs, look into VLOOKUP and HLOOKUPs, which are very powerful tools to let you treat a named range of cells as a flat database. (If you don't know what "named ranges" are, they're a way to assign a name to a block of cells on a spreadsheet/worksheet, and reference it by name in other spreadsheets.) > 2. I am also trying to copy the contents of this worksheet and plugging > it into a template formed worksheet. I need to break the Master down > into pages of 18 rows at a time, as the templates have preformated > headers and additional formulas and the cells also have format info that > I don't want to change. If I cut and paste all of the borders and font > info gets changed so that I have to go back and change it back. What I recommend is creating a second page, and setting the cells (with the formats you want) set so the contents look like this: ='Source Data'.H16' > TIA > Scott Castaline > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
