http://gyazo.com/47791b5dc0368fe3e1e001ef6d420582
Im working on this and as you can see in the picture about i have in the discount colum a percentage worked out,However to fill out the net cost i need to convert the percentage to make it into a price.
So for example the first one its 5.5% so i need to work out 5.5% of 2,600.00 and include that formulea in the formulea i already have in that cell to work out the percentage.
The formulea i used to work out the percentage is =IF(D4=1,$L$4,IF(D4=2,$L$5,$L$6)).The way that works is if there is one person going on holiday they get a 3% discount,2=5.5%,3=6.5%.
If you have any suggestions please post them
Im working on this and as you can see in the picture about i have in the discount colum a percentage worked out,However to fill out the net cost i need to convert the percentage to make it into a price.
So for example the first one its 5.5% so i need to work out 5.5% of 2,600.00 and include that formulea in the formulea i already have in that cell to work out the percentage.
The formulea i used to work out the percentage is =IF(D4=1,$L$4,IF(D4=2,$L$5,$L$6)).The way that works is if there is one person going on holiday they get a 3% discount,2=5.5%,3=6.5%.
If you have any suggestions please post them
