Question about Oracle Database Enterprise Named User Plus

2 Answers

EXCEL DATE RANGE FORMULA

NEED TO FIND A FORMULA TO CALCULATE THE LEAGUE AGE OF PLAYER. THE PLAYERS BIRTHDAY IS 9/7/1997, THE PARAMETERS FOR  LEAGUE AGE ARE 5/1/1997 TO 4/30/1998.

Posted by CGCG on

Ad

2 Answers

CNewton2

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 27 Answers

Assuming birthdate is in cell B2:

=IF(B2<DATE(1997,5,1),"Too Young",IF(B2>DATE(1998,4,30),"Too Old","OK"))

Posted on Oct 27, 2007

Ad

Anonymous

Bad

Posted on Dec 14, 2007

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

What is the age limit for little league?


(a) Little League (Major) Division: Any candidate with amateur status who will attain the age of 9 years before September 1, 2016, and who will not attain the age of 13 before May 1 of the year in question shall be eligible to compete in Little League Baseball (subject to the local league Board of Directors alignment ...

Aug 27, 2016 | Rawlings Youth Players Series 11" Little...

1 Answer

How should I set the v-window when I enter my distance equation?


The Window parameters control the width and length of the graphing screen. The distance equation is a formula to use to calculate the distance between two points known by their coordinates. The window dimensions have nothing to do with calculations. Or maybe I don't understand the question.

Sep 25, 2014 | Casio FX-9750GII Graphing Calculator

1 Answer

Do I need to get my son batting gloves for little league baseball?


Some people like to use gloves for batting if they are doing it often enough to cause callouses on the skin. They also help with gripping the bat but at a young age, they shouldn't have any problem. My daughter is an avid softball player, playing three to four times a week, and her hands are perfectly fine without gloves.

Jan 14, 2013 | Baseball & Softball

1 Answer

How many people must be in a room before the probability that some share a birthday becomes at least 50 percent? Use different values of n in the formula and approximate to the nearest n. show all work.


With two people in the room, the probability that the second person shares a birthday with the first is 1/365 (let's ignore leap years for the time being). Thus, the probability that they DON'T share a birthday is 364/365.

Add a third person. The probability that this person does not share a birthday with either of the first two (assuming they don't share a birthday) is 363/365. Thus, the probability that none of the three share a birthday is (364/365)*(363/365).

The probability that a fourth person doesn't share a birthday with any of the first three is 362/365. Thus the probability that none of the four share a birthday is (364/365)*(363/365)*(362/365).

See the pattern here? The probability of the n-th person not sharing a birthday is (366-n)/365. Keep adding people and multiplying the terms together until the probability of no one sharing a birthday drops below 0.5 --- which is when the probability of at least one pair sharing a birthday climbs above 50%.

Since this sounds like a homework problem, you'll have to do the rest.

Apr 21, 2011 | Texas Instruments TI-84 Plus Calculator

1 Answer

How do I use the Log button on this calculator? For example, I can't do the expression Log5(25) which equals 2. It turns out all funny.


The TI-30 XIIS, like most calculators, cannot do logarithms to base 5 directly. You need to apply the formula:
mib8888_1.gif
To calculate the logarithm at base 5 of 25, you key in: 25 [log] [ ÷] 5 [log] [=]

Jan 11, 2011 | Texas Instruments TI-30 XIIS Calculator

1 Answer

What button or formula do I use to calculate percentages


ok. first things first, percent mens, out of 100. you simply replace the percent with fractions. say you have $400. your workers get 20% of the money made each day. 20 out of 100=1/5 of 100.so your workers get 1/5 of the money which is 400 divided by 5 wich equals 80. i hope this helps. if you still have trouble, serch on the internet for the formula for calculating percent.

Aug 05, 2010 | Adler Royal Royal 1228 Calculator

3 Answers

Fibonacci formula won't graph, but will show table


Fibonacci sequence is the series of numbers 0, 1, 1, 2, 3, 5, 8, 13, 21, 34, ...
At first type Fibonacci equation in Y editor with condition x>=0 and then graphing it. See captured images with enlarged form of graph

7_31_2012_12_55_37_pm.jpg


7_31_2012_12_57_51_pm.jpg


7_31_2012_12_58_57_pm.jpg

Apr 11, 2010 | Texas Instruments TI-84 Plus Silver...

1 Answer

How do I see the league table for the Vodacom League in Cape Town area


http://www.safa.net/index.php?page=logsnresults

1. League [select] 2. Season [select] 3. Province [select]
> view logs < for league table : > view results < for match results.
play on :-)

Sep 11, 2009 | Safa Audio Players & Recorders

1 Answer

Sumif function....


Use the following formula as an array formula, you need to hit "Shift+Ctrl+Enter" after entering the formula. Lets say you have the Name in column "B", the Age in column "C" and the amount paid in column "D". Here is the formula.
=SUM((B2:B7="Abhilash")*(C2:C7>0)*(D2:D7))

It will calculate the amount paid if the name =Abhilash" and the Agr is greater than zero.

Apr 11, 2009 | Microsoft Works 8.0 for PC

2 Answers

Excel formulas


Here is your formula

=IF(A1 < 25,10/100 * B1, 5/100 * B1)

A1 is the Age of client
B1 is the car value


Oct 27, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Oracle Database Enterprise Named User Plus Logo

Related Topics:

5,846 people viewed this question

Ask a Question

Usually answered in minutes!

Top Oracle Computers & Internet Experts

Poul Brinchs Larsen

Level 2 Expert

159 Answers

STEVE

Level 3 Expert

34909 Answers

JonSnell Electronic
JonSnell Electronic

Level 3 Expert

30925 Answers

Are you an Oracle Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...