eligible

  1. D

    Conditional formating with a formula

    I have a spreadsheet of 1400 students and I'm trying to find which ones are eligible for our program. I have adjusted gross income in one column and dependents in another column. I have a countifs that accurately tells me how how many are eligible. But I can't figure out how to highlight the...
  2. D

    IF AND OR Formula

    Hello I am trying to complete a formula for the following I want to check that if the value in NMI MIRN State says VIC OR NSW OR QLD then the value in Annual Peak KWh needs to be greater than 100000 or IF NMI MIRN State says NSW or SA then the value in Annual Peak KWh needs to be greater...
  3. L

    Tiered Commissions Calc

    Hi, I was wondering if someone could help me with this. I have a tiered commissions structure as follows: 0-100% attainment (Total payout of 100% of eligible %) 100-125% (total payout of 1.5% of eligible %) 125%+ (total payout of 2.5% of eligible %) accelerated commission rate not to exceed 15%...
  4. J

    Creating Relationships (of person's name) in a Data Model where 2 people have the same name (but different bdays)

    I’m working on a PC using the Office 365 suite. I know that there are work arounds for this issue, but I am trying to understand Data Models better and thought this would be a great way to practice (as it needs to be done anyway), yet I’ve already gotten stuck! Here the problem: I have 2 tables...
  5. M

    how to handle repetitive errors in excel vba?

    Dear All, I written small VB code to check codes are existing in other sheet or not. If code is not exiting in other sheet it should populate "not eligible" instead of "eligible" I have 3 sheets in workbook (sheet1: 5000 ID's along with other columns as a PIM and column A as a PIM1 / sheet3...
  6. V

    match 3 criteria in excel

    SALES 65000 103000 161000 CRITERIA 1 50000-99999 100000-149999 150000-199999 CRETERIA 2 12 16 24 CRETERIA 3 3% 3.5% 4% REQUIRED YOUR HELP PLEASE...
  7. D

    Signatures

    How do u make a signature? it says sorry, you are nor eligible or something like that?
  8. D

    Need VBA Code for the below scenario

    Hey Guys, Below is the scenario to write VBA code:- > If Score is > 900 > If Income is > 600000 > If Occupation = "Salaried" and Income > 500000 > If Marital Status = "Single" > If Own house = "yes" 1, If any one of the above criteria met result should be "Loan Eligible" 2, If any one of the...
  9. M

    Conditional Formatting

    Hi Guys, Definitely a stupid question, but.... I want to highlight every instance of the text string "eligible" when I return a lookup value in a table. Unfortunately, it also appears to highlight other string returns such as "Non eligible". How can I ensure that it just highlights just...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top