I pay for help but it seems like i cannot get it. i sent in questions that i had to you. I need to know how to put the information into excel.

Charlie wants to calculate his gross monthly sales commissions. The rule is that he receives a commission of 2.5% of his total monthly sales if he sold more than $400,000 worth of vehicles. Otherwise, he only gets 1.5% of his total monthly sales amount.

In cell B31, create a formula using the IF function to check whether the value of cell B9 is greater than 400000.

If this condition is true, the function should multiply cell B9 by 2.5% to determine Charlie’s commission. (Hint: For the if true value, use B9*0.025.)

If this condition is false, the function should multiply the value in cell B9 by 1.5% to determine Charlie’s commission. (Hint: For the if false value, use B9*0.015.)

Copy the formula in B31 to the range C31:G31.

After deductions, Charlie’s net monthly commission is only 85% of his gross monthly commission.

In cell B32, create a formula that multiplies the value of cell B31 (Charlie’s gross monthly commission) by the value of cell B33 (Charlie’s net commission percentage). Use an absolute reference to cell B33 (because the net commission percentage won’t change) and a relative reference to cell B31.

Copy the formula in cell B32 to the range C32:G32

Using the Format Painter, copy the formatting from the range G5:G9 to the range H5:H9.

please give me instructions on how to put it in excel

I need this by 12 noon tomorrow

Thanks

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

I signed up to see what this was about because I saw it said you can cancel it any time. I wanted to cancel it now. But does that mean I’m still paying 125 dollars for the year. This was confusing I thought I was only paying the 10 dollars for one month.

Rachel

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

I solved problem 1 and I have trouble with problem 2/ part A .. My answers are attached I need help with problem 2 and matlab code would be helpful

m – mw2r = -mg sin(wt)

When m = contestant and w = constant

D2 r – r w2 = -g sin(wt)

(D2 – w2 ) = 0

Therefore, m =

r(t) = A sin wt + B cost wt

r'(t) = A w cos wt – B w sin wt

r” (t) = – A w2 sin wt – B w2 cost wt

mr” (t) – mw2 r = -mg sin wt

A = g/2w2

r(t) = rh (t) + rp (t)

r(t) = C1 ewt + C2 e-wt + sin wt

r0 = C1+ C2

r'(0) = V0

C1 = – +

C2 = – + 

R(t) = [ – + ] e-wt + [ – + ] ewt +  sin wt

r(0) = 0

r(t) = [ – ] e-wt + [ – ] ewt + sin wt

t  

ewt 

e-wt 

Therefor,

r(t) = [ – ] e-wt + sin wt

This because to be simple harmonic A = B = 0 and r(0) = 0. We have A = -B this is only possible when v0 = g/2w

For minimum length of the rod r'(t) = 0

 [ – ] (-w) e-wt + cos wt = 0

Cos wt = [ ½ – ] e-wt

R(t) = sin wt

W = 2 , V0 = 2.4 , 2.45 , 2.5

0 t 5

r0 = 0

r(t) = [ 9.81/16 – 2.4 /4 ] e-2t + 9.8/8 sin 2t

r(t) = [ 9.81/16 – 2.45 /4 ] e-2t + 9.8/8 sin 2t

r(t) = [ 9.81/16 – 2.50 /4 ] e-2t + 9.8/8 sin 2t

• Attachment 1
• Attachment 2

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

**The content below will NOT be used to cheat in any sort of way** please help me solve the following. I spent 2 hours on it already trying to figure out how I ever got some right or wrong. I am preparing for the next semester. Thank you.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"