plans

Hello, I have a workbook with 2 sheets. Sheet 1 contains 3 rate plans all with their own checkbox (form) 1. Basic 2. Advantage 3. Gold I have a second sheet that all the inclusions of the rate plans. I have added on the top of the sheet the rate plans and a check box next to the inclusion...

Hi Excel Experts, I have two columns, A contains Planned LOC Years (2019,2020 and 2021, no plans ,etc), B savings in dollars sometime neg (with savings) and sometimes postive (no savings) and blanks or sometime also zero. I want to count in the summary sheet all line with savings both negative...

I have this in cell K5: =IF(OR(ISNUMBER(SEARCH({"SLAB - GL","SLAB - GR"},$G5))),"Slab","Floor Plans") I would like to combine that with this: =IF(OR(ISNUMBER(SEARCH({"Open Web"},$G5))),"Open Web","Floor Plans") I ended up with this, but it gives me a #VALUE!: =IF(OR(ISNUMBER(SEARCH({"SLAB -...

Can some math genius please help me? I wish to reckon the base prices for extended healthcare plan. There are three classes in the plans: Health, Dental and Prescriptions. Each of those three classes has three available variables: A, B and C. By clicking through the co's website, I was able to...

Hi, I am making a pivot chart (bar graph) to represent the number of transactions that happened in 196 plans. There are many plans with less than 3 transactions, and i would like to group them all together to be represented by a single bar called "All Other Plans". Is there a way to do this...

01-12-2018 Greetings, My question relates to my desire to use a spreadsheet to compare various Medicare health plans – and I thought this group might have some ideas. Background. I’ve gone to Medicare.gov to obtain information about available Medicare health plans – and I find the site...