subject

PLEASE, HELP My table will be attached. I need an excel formulas.
If the seniority is less than 5 years there is no bonus.
•If the seniority is greater than 5 years and less than 15 years the bonus is 15% of the salary.
•If the seniority is greater than 15 years the bonus is 20% of the salary.
•Payment.
•Display the list of employees whose seniority is greater than 15 years.
•Display the list of employees (name and surname) who had been hired the current year and have their payment under average.
•How many employees haven’t received a bonus?
•What’s the total amount of money paid to the employees with seniority greater or equal to 15 years?


PLEASE, HELP

My table will be attached. I need an excel formulas.
If the seniority

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 13:30
In your ice breakers game, what happens when the snowball collides with one of the snowboards? a. the player's score will increase. b. the snowball will leave the play area. c. the snowball will be destroyed. d. the snowball will bounce.
Answers: 1
question
Computers and Technology, 22.06.2019 06:00
Write a program that uses a widgetviewer object to do the following: generate two random integers between 1 and 9 (inclusive). name one of them x, the other y. display them to the user using jlabel objects. create a jlabel object displaying the text "enter an operation number." create a jtextfield for the user's input. create a jbutton displaying the text "press here when you've entered your operation." use addandwait to add it to the widgetviewer object. when the user clicks the jbutton, evaluate operation in the following order to determine the one and only mathematical operation to perform on x and y. use a jlabel to display the result. if operation is between 1 and 10 inclusive, add x and y. if operation is evenly divisible by 4, subtract y from x. if operation is evenly divisible by 5, use integer division to divide y into x. if operation is an even number, use floating point division to divide y into x. if none of the other tests on operation apply, multiply x and y. note: operation can be negative or zero.
Answers: 2
question
Computers and Technology, 23.06.2019 03:00
Jason, samantha, ravi, sheila, and ankit are preparing for an upcoming marathon. each day of the week, they run a certain number of miles and write them into a notebook. at the end of the week, they would like to know the number of miles run each day, the total miles for the week, and average miles run each day. write a program to them analyze their data. your program must contain parallel arrays: an array to store the names of the runners and a two-dimensional array of five rows and seven columns to store the number of miles run by each runner each day. furthermore, your program must contain at least the following functions: a function to read and store the runners’ names and the numbers of miles run each day; a function to find the total miles run by each runner and the average number of miles run each day; and a function to output the results. (you may assume that the input data is stored in a file and each line of data is in the following form: runnername milesday1 milesday2 milesday3 milesday4 milesday5 milesday6 milesday7.)
Answers: 3
question
Computers and Technology, 23.06.2019 04:00
Another name for addicting games.com
Answers: 1
You know the right answer?
PLEASE, HELP My table will be attached. I need an excel formulas.
If the seniority is less t...
Questions
question
Computers and Technology, 18.11.2020 18:20
question
Mathematics, 18.11.2020 18:20
question
Chemistry, 18.11.2020 18:20
question
Mathematics, 18.11.2020 18:20
Questions on the website: 13722367