Skip to main content

Customer order Microsoft template

I am using Microsoft template to manage orders on my website. This template allows me to see the total price with tax that user need to pay.


This formula sums up price in exact row when conditions are made. If cell A18 is not equal 0, formula multiplies cell A18 which is quantity of product by price in cell E18 and if the condition is made it shows sum in cell G18. If the condition is not made cell G18 shows just blank space. Formula is the same for cells from A18 to G37.


The cell G39 sum up every value in cells G18 to G37 if condition is made. Again, if value in any cell between G18 and G37 is bigger than 0, then cell G39 shows sum of all values greater than 0. If there is no value greater than 0 then this cell shows blank space.


This cell is again conditional cell. If the sum of cell G39 is greater than 0, then this cell multiplies value of cell G39 by tax rate in cell G40 to get total sum of all product with tax rate. If tax rate in cell G40 is equal 0 or null, then total value is equal the same value as it is in cell G39. Else if Subtotal value in cell G39 is equal to 0, then total sum in cell G41 shows blank space.

Comments

Post a Comment

Popular posts from this blog

Survey results and analysis + SWOT Analysis

In the last weeks I have created a survey to gather informations, which can potentially give me some ideas about my software and how I can improve it in order to fulfil expectations of potential clients. To analyse all of data gathered I used charts that were generated automatically in the Google Forms and SWOT Analysis of data in charts. In the first part of my survey I am asking respondents about themselves do predict if there are any chances that they are on some higher positions in companies that they are working for. The variation of both higher age and higher education - age 30+ and bachelors level of education and above makes possibilities that the respondent is currently on some higher position. I decided to use this variation instead of asking respondent directly, because I am aware of that maybe not everyone want to share such information with survey even if they are anonymous. As we are able to see on the chart there is an impressive number of people who have educati...
3 comments
Read more

SEO

SEO (Search Engines Optimisation) - It is about optimising web pages for the search engine to be as high in search engine as possible. To optimise web page we have to use correct tags, words, web page structure, link to partners and social media. In order to do SEO on the page correctly we have to know how exactly the SEO works. SEO is used to make websites visible in the search engine on the highest position. Optimisation is also used to have high Click Through Rate (CTR) to monetise websites.
2 comments
Read more

Google - Case study with reflection + link to Google docs

The case study can be accessed from: https://docs.google.com/document/d/18tfwey_ZNtgt6GL4LtRNodJPLf6IAsNPKpb-A6ZqH78/edit?usp=sharing Google – Company and services Google is a company founded by two students of the Stanford University – Larry Page and Sergey Brin in 1995 (Google, n.d.). They started from a project of the page, which is indexing other pages in the web to be accessible from one place and with that kind of solution other students started to use their product. Further, they have caught the attention of big investors and some of this investor coming from Silicon Valley. Investors were that interested in the solution of two students that they have decided to give them a cheque for a $100 000 and this is how the company has grown from a small garage project to an official Google Inc. in 1998 (Google, n.d.). The Google company offers many different services. Various services can be used by different groups of people like regular users. A regular user has ac...
1 comment
Read more