Google Sheet Help..... (beginner)

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




Thank you very much

 

@kenny1999 open this file with Google Sheet/Excel/OpenOffice Calc/whatever.

 

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)

 

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

 

@kenny1999

 

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

 

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

 

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

 

@kenny1999

 

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.

 

@kenny1999 you're welcome. This website should help with formulas and stuff. I never used Google Sheet in particular, but from my understanding all these apps work pretty much the same.

 

great tutorials that solved me problesm

I also want to make three excel tables in which three of them are co-related to each other

The first table is Monthly record of expenses, and calculating the total expenses
The second table is Monthly record of income, and calculating the total income

The third table is a combination of expenses and income, listing the detailed items of expenses and income,arranged according to dates, data automatically generated from the 1st and 2nd table,
and generating the total amount of either gain or loss at the end.

excel is more easy than i ever expected. Now I 've successfully created two sheets , one is expenses and another is income, feeling so satisfied

 

I am now able to create two sheet of income and expenses,

but I don't know how to automatically generate a list of both income and expenses on the same sheet and listed according to dates.