Coursework.Info - Inspiration in an Instant

On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:

The Diary 19/02/2002 Today I set up the input, process and invoice screen according to the hand drawn plan and the functions and calculations according to "The Workbook" section. I did not set-up any validation checks, macros or cell protection. I simply wanted to see if this section of the system would function correctly. Input Process Problem On the process sheet I had difficulty setting up the 'Discount on spending' cell. I used the formulae: =IF(G21>300,40,G21>200,20,G21>100,10,0) However this formula would not work and error messages came up. After looking at Microsoft help I realised my mistake. After the "Otherwise" comma in the formula another if function has to be used. So the corrected formula is =IF(G21>300,40,IF(G21>200,20,IF(G21>100,10,0))) Invoice Problem If room selection 2 was left blank on the input screen then the invoice looked as follows If there is only one room ordered I wanted the second row of the invoice table to be blank. To do this I added an IF...

Get instant access

• Instant, unlimited access to our documents in full
• Swap your work for free access, or pay £4.99
• To see the full version of this document and 147,050 others

OR

Receive email updates for this category

• Simply tell us your email address and receive a weekly Study Help Email for FREE
• Receive 3 FREE essay views with each email
• Get all the latest essays from Coursework.Info & discussion from TheStudentRoom.co.uk