Search:

Type: Posts; User: chriskenny; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    1
    Views
    63

    Inserting date

    Hi, is it possible when I click on a cell it inserts the current date. I do not want this to update on every cell.

    Thank you
  2. Replies
    4
    Views
    209

    Re: Conditional formatting rule

    Thank you, but I did try these but it did not format across the whole sheet and in places I should not have.

    For some reason I cannot attach screen shots, so I have done my best to show rule


    ...
  3. Replies
    4
    Views
    209

    Conditional formatting rule

    I have a conditional rule in cell I2 if less than 02:00 and want to know how I would apply the rule so it colours the whole row from A2 through to K2

    Thank you
  4. Replies
    9
    Views
    481

    Re: Formula deduction

    Thank you, worked perfect
  5. Replies
    9
    Views
    481

    Re: Formula deduction

    Thank you, worked perfectly. Sorry if confused, trying to get my head around it all :)
  6. Replies
    9
    Views
    481

    Re: Formula deduction

    Thank you for your assistance and it works for the first row but when I drag down to the second row it is applying a refund when it is not due

    https://docs.google.com/spreadsheets...it?usp=sharing
  7. Replies
    9
    Views
    481

    Re: Formula deduction

    Thank you for your assistance and it works for the first row but when I drag down to the second row it is applying a refund when it is not due
    ...
  8. Replies
    9
    Views
    481

    Formula deduction

    I have created a spreadsheet in google sheets and I am having problems with the following formula. Please see attached link to the google sheet.

    In column K the formula works out the figure after...
  9. Replies
    6
    Views
    249

    Re: Splitting commission

    I did not realise I would upset people by doing this and I apologise. I would have marked as solved once I had answer.
    I have posted in the following:...
  10. Replies
    6
    Views
    249

    Splitting commission

    <tbody>

    <tbody>
    M

    N

    O

    P
  11. Replies
    5
    Views
    193

    Re: Counting commission & formula /text

    yes, what you gave me worked for insertion of one formula but when I tried to insert a second formula in the same cell I kept getting an error.
  12. Replies
    5
    Views
    193

    Re: Counting commission & formula /text

    Sorry what I am trying to do is insert two formulas within a text statement, so it would start Hi, (then the name of the person is drawn from the cell in another worksheet) I then continue to write...
  13. Replies
    5
    Views
    193

    Counting commission & formula /text

    Good Morning

    I would like to combine text and formula's for example it would star Hi, and then take the info from the sale sheet by date cell B2 then continue with text blah blah blah and then...
Results 1 to 13 of 13