Google Sheet Help..... (beginner)

Discussion in 'Windows OS and Software' started by kenny1999, Sep 25, 2017.

  1. kenny1999

    kenny1999 Notebook Consultant

    Reputations:
    10
    Messages:
    281
    Likes Received:
    18
    Trophy Points:
    31
    I am making a Google sheet , for the first time. I have NO knowledge of excel

    Now, in column A, it's the names of my products
    In column B, it's the corresponding prices of each product.
    In column C, it's the prices after 80% discount
    In column D, it's the prices in another currency with fixed rate

    Obviously , items in column A and prices in column B are defined by me.

    I'd like the Excel or Google Sheet to automatically generate the prices in column C after 80% discount and in column D, it's the prices in another currency with a conversion rate defined by me

    but how to??

    for example
    [​IMG]



    Thank you very much
     
    Last edited: Sep 25, 2017
  2. Starlight5

    Starlight5 I'm a cat. What else is there to say, really?

    Reputations:
    210
    Messages:
    2,155
    Likes Received:
    728
    Trophy Points:
    131
    @kenny1999 open this file with Google Sheet/Excel/OpenOffice Calc/whatever.
     

    Attached Files:

    kenny1999 likes this.
  3. kenny1999

    kenny1999 Notebook Consultant

    Reputations:
    10
    Messages:
    281
    Likes Received:
    18
    Trophy Points:
    31

    Thank you very much

    I didn't think you did it for me. I thought you taught me how to do, as a result, I simplifed my situation.

    Can you made this for me

    column A = product name
    column B = marked price in EUR(defined by me)
    column C = marked price in another currency with a conversion rate that I can
    define at anytime later
    column D = marked price in EUR without VAT ( divid by 1.19 )
    column E = marked price without VAT in another currency with a conversion rate that I can define at anytime later
    column F = prices in column C x 1.1 or 1.2 or 1.3 or.... (I define)
     
  4. kenny1999

    kenny1999 Notebook Consultant

    Reputations:
    10
    Messages:
    281
    Likes Received:
    18
    Trophy Points:
    31
    i.e.

    column A = product name
    column B = marked price in EUR
    column C = column B x rate1
    column D = column B / 1.19
    column E = column D x rate1
    column F = column C x rate2

    rate 1 and rate 2 can be changed at anytime
     
  5. Starlight5

    Starlight5 I'm a cat. What else is there to say, really?

    Reputations:
    210
    Messages:
    2,155
    Likes Received:
    728
    Trophy Points:
    131

    Attached Files:

    kenny1999 likes this.
  6. kenny1999

    kenny1999 Notebook Consultant

    Reputations:
    10
    Messages:
    281
    Likes Received:
    18
    Trophy Points:
    31

    Thank you very much !! Highly appreciated !!

    Can I do anything to make the values in column D and column E less digits at the end?

    For example 84.03361345 ---> 84.03 if it's less than 5 or 84.04 if it's 5 or more

    And how to copy the whole functional table to another sheet? Just select all the cells and hit copy and paste?

    Thanks again for the input!!
     
    Starlight5 likes this.
  7. Starlight5

    Starlight5 I'm a cat. What else is there to say, really?

    Reputations:
    210
    Messages:
    2,155
    Likes Received:
    728
    Trophy Points:
    131
    @kenny1999 select D & E columns, right click on them, select Format Cells (or something like that - I'm using OpenOffice, after all), there choose the appropriate format. You can indeed select and copy everything to another sheet. Good luck!
     
    kenny1999 likes this.
  8. kenny1999

    kenny1999 Notebook Consultant

    Reputations:
    10
    Messages:
    281
    Likes Received:
    18
    Trophy Points:
    31
    can you help too ? make it two decimals only? (for column D and E) I've tried, but I am not able to figure out how to make it.

    sorry ... thank you
     
  9. Starlight5

    Starlight5 I'm a cat. What else is there to say, really?

    Reputations:
    210
    Messages:
    2,155
    Likes Received:
    728
    Trophy Points:
    131

    Attached Files:

    kenny1999 likes this.
  10. kenny1999

    kenny1999 Notebook Consultant

    Reputations:
    10
    Messages:
    281
    Likes Received:
    18
    Trophy Points:
    31
    Thank you

    Can you teach me a little bit how to make it? (Google sheet)
    I cannot rely on you forever

    For example, I have a column A with user defined value
    and I want to have another column B which is equal to column A x rate 1

    where rate 1 can be defined by me.
     
Loading...

Share This Page