Sales order Excel sheet

-
It is very important to have an order form a business e-commerce website.The order form is to check the orders you have in the website and manage items when a costumer want to receive the fresh vegetables and fruits.



This customer order sales Excel sheet in using Formula. Now i am going to talk about some formulas. First of all,=IF(SUM(A18)>0,SUM((A18*E18)-F18),"") is an autosum  formula. it's working Raw1, column 18 Multiply with Raw5, column 18 but if there any discount, it will go same process accept subtraction Raw6 column 18.

Comments

  1. Carrie Mansfield10 March 2018 at 03:30

    In Excel the columns are the letters and the rows are the numbers, so it would be column A, column B etc., and row 1, row 2, etc. This gives each cell within the worksheet an address, which is A18 (for example). Just make sure you have these column and row references the right way round!

    ReplyDelete

Post a Comment

Popular posts from this blog

DBMS

-
A Database Management System is called DBMS. DBMS is tool to store, edit and organise data in rows and column. It's have some features:                                      1. Stores data in one central location.                                      2. Allows data to be shared by many users.                                      3. Provides user interfaces (UI)  to work with the data                                      4. Controls who can access and edit the data. Benefits using a DBMS:                                      1. Integrity                                      2. Efficience                                      3. Consistency                                      4. Backups                                      5. Security                                      6.Customisation Examole of database:                                            1. Two individual database.                                                Example: Online sales.                  
Read more

Email is working

-
Image
My email is working and i can respond those email as well. I have added my email contact on my about pages. This is very important for connecting customer. Also find there comments about website and  products.
Read more

Case study 2

-
Image
My further research about on this company I have found recently(2018) they published a news called " Cyber-Security Attacks Already Happening in Business Aviation" I was trying to find what type of company or organisation was suffering from this attack but there were no clear information about company because of privacy and customer satisfaction. This news also describe that daily attacks and how to secure the environment. I n this case study I explained  how AIN company was founded and who was the founder, what  services are the offered. Sources: https://www.ainonline.com/aviation-news/business-aviation/2018-04-12/cyber-security-attacks-already-happening-business-aviation
Read more