Information Technology Development Cycle Diary

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 function in front of the formulas in the cells. So the formulas changed (see next page). This meant if only one room was ordered the second row of the invoice table would be blank.