# Formulas: copy cell format to range of cells?

• I need more help please.
I need to copy a formula to range of cells.
(Cell C4 ) =B4* (1+ \$B\$22)*(1-\$B\$23)
ok I put that in cell C4 now I need to copy C4 to range D4:H4
can someone tell me how to do this. I am pullling out my hair with these problems. thanks if you can help me.

• Gidday Kalijwv,

There are a few ways to do this, the simplest is highlight cell C4, put the cursor on the little black dot on the bottom RH corner of the cell (a cross appears when cursor moves over that point) hold down your left mouse key and drag.

Check the formulii are what you want and go for it!

Reply to this post if further details are required,

Cheers from DU, GB

But I always say luck is where preparation meets opportunity (Justin Langer 23/11/01)

• ok, will try that, see if it works for me. If it doesn't I will be back. lol thank you. Cleta;;)

• Thank you Thank you LOL I got it to work, been trying to do this for over an hour. I have to do this to several cells, so now I think I got it. It is so nice of you to take the time to help me. I really appreciate it.
Cleta:wink1:

• Cleta,

Your very welcome, do not hesitate to ask if you have other difficulties, some of the other people on this forum are very very very smart,

Cheers,

Graham

But I always say luck is where preparation meets opportunity (Justin Langer 23/11/01)

• Graham, I need your help again. ok
I have IF functions to write and need help with them.
I need to enter an IF function that applies the following logic.

If hours <= 40, then Gross Pay =Rate * Hours, otherwise Gross Pay = Rate * Hours + 0.5 * Rate * (hours - 40)

If (gross Pay - Dependents * 38.46), otherwise Federal Tax= 0

I know you can't write the function without knowing what cell each of these are in, but the hours for the first one is in C4 40.25 hours.
B4 rate
F4 gross pay.

second one
F4 gross pay
D4 dependents
Can you help me with this??
Cleta

I know I copy the IF function in F4 the Gross Pay cell.

• Hi Cleta,

Pleasure to help,

the first formula is in cell G1 (say)

=if(c4=<40,b4*c4,b4*(c4-40)*1.5+b4*c4)
(it reads if c4 is equal to or less than 40, then hours * rate, otherwise all the hours above 40 are time and a half plus 40 hours at normal time.

If (gross Pay - Dependents * 38.46)>=0 ????, otherwise Federal Tax= 0

if it is something like that then

=if((G1-d4*38.46)&gt;0,"Fed Tax to be paid","No Tax Paid")

in the above equation, put your calculation into the "Fed Tax to be paid"

I hope this helps,

Graham

But I always say luck is where preparation meets opportunity (Justin Langer 23/11/01)

• Hi, Graham,
The first one worked fine. I think I gave you the wrong thing for the 2nd one. It was written like this.

In cell I4, enter the IF function that applies the following logic;
if (gross pay-dependents*38.46)&gt;o, then federal tax= 20% * (gross Pay- Dependents * 38.46), otherwise fed tax =0

Will you try it again for me?

F4 is gross pay
D4 is dependents
I4 is fed tax this is where I enter the function.
Cleta
I know I am being a pain but this is my last problem then I have some extra credit problems to do and 3 problems that are part of my test. then I will be finished with this class. except for taking my finals.

I have just been so confused lately, I just lost my only brother and its been so hard for me to concentrate on this stuff. and I only have until the end of this month to finish this and to a class on Power point which I am afraid I won't get done in time. So I really appreciate you help. I have been up all night working on this.
my email is [email protected] can I have yours?

• Hi Cleta,

Your written equation is correct, just substitute cell addresses and you are on fire.

if (gross pay-dependents*38.46)&gt;o, then federal tax= 20% * (gross Pay- Dependents * 38.46), otherwise fed tax =0

=if((f4-d4*38.46)&gt;0,(f4-d4*38.46)*.2,0)

Hope this works.

I have a number of emails that are all open to my office (and therefore public), the best way to catch me is through this forum which I leave on about 10 hours a day or [email protected]

No problem about helping where I can on Excel but I am c**p on powerpoint

Cheers,

GB

Edited for language. Will

But I always say luck is where preparation meets opportunity (Justin Langer 23/11/01)

• Sorry to hear you lost your sister, I lost my youngest sister (48yrs old) 3 yrs ago also. June 5th 2000. cancer. My brother died Aug 21st, 2003 seems like yesterday to me. My daughter got cancer, (lymphoma) 1 year before my sister died. Thank God she is ok now, but still has a lot of problems from her treatments. she is 33 now. All this just in the last 4 yrs has made it really hard for me. Both my kids are married I have been divorced since 94 so being by myself trying to deal with all this with no one to talk to about any of it has really got me down. I started back to college last year hoping it would keep me busy, but I have a hard time concentrating on these computer classes. I have finished 5 other classes with no problems its just these IF functions, formulas etc. I just can't understand them no matter how hard I try. I was able to get some of them just going by the ones you have helped me with, then they throw in one that messes me up again. I know you are busy and I do appreciate all the help you have given me. I only have 4 more functions to put in then I am finished, I will see if I can find someone else to help me with them so not to keep bothering you. So thanks again Graham for helping me. You have been my angel.
Cleta

• Afternoon Cleta,

You are not having the best of times. My sister 41, passed away on 6 June 2000.

For you last 4 problems, post them on the forum, if I cannot help there are some brilliant minds that can.

Kind regards,

Graham

But I always say luck is where preparation meets opportunity (Justin Langer 23/11/01)

• I need to write an IF function using the following logic to determine the social Security tax for cell G4.

If Soc. Sec. Tax * Gross Pay + YTD Soc.

sec. &gt; Maximum Soc. Sec., then Maximum

Soc. Sec. _ YTD soc. Sec., otherwise Soc.

Sec. Tax* Gross Pay.

F4 is gross pay

E4 is YTD

G4 is Soc. Sec

I am not sure how to put this in an IF function because of Maximum Soc. Sec.,

Can someone show me how to write this.?

I started it like this:

=IF (G4* F4 + E4)&gt; now what do I put?

HELP going nuts here.

Another one is.

Medicare = Medicare Tax * Gross Pay

H4 medicare
F4 gross pay
E4 YTD soc.sec.

third one is:

=Gross pay- (soc.Sec. + Medicare + fed. Tax + State tax)

F4 gross pay
G4 soc. sec.
H4 medicare
I4 Fed Tax
J4 state tax

need this in IF function entered in K4

I know this is a lot to ask but hope this will finish this problem I am working on now. Thanks if anyone can help
Cleta

• Assuming your "Max Soc Sec" is in C4

=IF(((G4*F4) + E4)&gt;C4,C4-E4,G4*F4)

Will

• I am not sure what they mean by Maximum Soc. Sec. The following is all that I have in each cell.

B4.....Rate
C4.....Hours
D4.....Dependents
E4.....YTD Soc. Sec.
F4.....Gross Pay
G4.....Soc. Sec.
H4.....Medicare
I4......Fed. Tax
J4......State Tax
K4.....Net Pay

So is YTD the same as maximum Soc. Sec.
Hope this will help. Also I still need help with the other 2 I posted with this one.
Thanks Cleta

• I would hazard a gues that Max Soc Sec is a fixed ceiling number set by the "powers that be" i.e. maybe your IRS.... ?

I believe in the UK we have an "Upper Earnings Limit" on which we pay National Insurance Contributions at a fixed 10%(similar to your Soc Sec i believe). Given that, there must be a maximum that you pay (although in the UK, the Labour Govt are removing the Maximum for tax year 2003-4 :mad: )

So maybe you need to investigate this to find out what the "theoretical maximum" is.... your IF statement then does a test to see if that has been reached before applying any further payroll deductions, so you'll need to know the figure!!

Hope this helps,

Will

• ok, thank you. did you check the other 2, I put on with this one the first time, I haven't figured them out either, can you help me with those.
thanks again, oh, by the way, I just received an email that I got a virus from this forum. Had to be from someone that answered this post, Check for a virus on your computer.

• i'm fairly sure you can't have "got a virus from this forum" unless you downloaded a file containing a virus - and I doubt there are any, certainly not in this post.

What exactly does the email say & who sent it ?

As for your other 2 formulas

1. =F4 * "medicare tax"
(you need a cell that contains the tax % for medicare - I have no idea what that may be.

2. =F4-SUM(G4:I4)

Hope this helps,

Will

• Thanks Will, I wish I had kept the email about the virus so I could have let you read it. I have been getting email from something called microsoft, several a day, after my virus scanner caught the virus and got rid of it, I have received more email from this microsoft thing and all it has is a paper clip no title, and there is writing above it that says "outlook blocked access to the following potentially unsafe attachments. So this must be where the virus came from, but the email address on the first thing I got had, like I told you several address with the word ozgrid.com etc on them.

To Pesky, this is for you :P:P:mad: LOL

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!