Formulas: copy cell format to range of cells?

  • I need more help please.
    I need to copy a formula to range of cells.
    this is how it reads.
    (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)

  • 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,

    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,



    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
    not sure about the 38.46.
    Can you help me with this??

    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)

    (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,


    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.
    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,

    Sorry to hear about your brother, I lost my sister about 3 years ago - terribly sad.

    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


    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



    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.

  • 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,


    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)


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

    E4.....YTD Soc. Sec.
    F4.....Gross Pay
    G4.....Soc. Sec.
    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,


  • 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,


  • 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 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!