hey guy, I was wondering if you guy could help me with the command that needs to

Question

hey guy, I was wondering if you guy could help me with the command that needs to beplaced into excel in order to fulfull the following:

Discount: Employees who have worked more than 3 years get a 5% discount. Employees who have worked more than 5 years get a 10% discount. Employees who have worked more than 7 years get a 15% discount. Anyone who has worked less than 3 years does not get a discount.

I think I must use a =if( ) command but I have no idea how to do it with all the ranges such as >5 but <7 type of thing in this command line; when I place commas it assumes something else.

Explanation / Answer

I'm taking 20 employees as a sample data (A1:A20) = joinging date

=if(CurrentDate - A1:A20 > 3, (B1:B20) + ((B1:B20) * (5/100), "No Discount"),

=if(CurrentDate - A1:A20 > 5, (B1:B20) + ((B1:B20) * (10/100), "No Discount"),

=if(CurrentDate - A1:A20 > 7, (B1:B20) + ((B1:B20) * (15/100), "No Discount")

for current date use CTL + ;

you should provide sample data or else to clarity puroise.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.