eligible

Hi I have a counter with a minimum value of 17. As long as this value is not reached, then extra dates should be added to an array of dates. The extra dates should be workdays: if for example 2 extra dates are needed to reach the 17 value, but the 24th of December is not a workday, yet 23rd and...

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...

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...

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%...

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...

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...

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...

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

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...

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...