Jun 01 2022 08:35 AM
Memo No. | Date | Guest | Cost per capita | Total Cost |
1 | 5-May-22 | 31 | 32 | 992 |
2 | 8-May-22 | 40 | 30 | 1200 |
3 | 9-May-22 | 30 | 40 | 1200 |
4 | 10-May-22 | 73 | 16 | 1168 |
5 | 11-May-22 | 58 | 20 | 1160 |
6 | 12-May-22 | 48 | 25 | 1200 |
7 | 16-May-22 | 29 | 40 | 1160 |
8 | 17-May-22 | 24 | 25 | 600 |
9 | 18-May-22 | 40 | 30 | 1200 |
10 | 19-May-22 | 58 | 20 | 1160 |
11 | 22-May-22 | 50 | 20 | 1000 |
12 | 23-May-22 | 40 | 25 | 1000 |
13 | 24-May-22 | 30 | 40 | 1200 |
14 | 25-May-22 | 29 | 40 | 1160 |
15 | 26-May-22 | 40 | 23 | 920 |
16 | 29-May-22 | 50 | 20 | 1000 |
17 | 30-May-22 | 50 | 20 | 1000 |
18 | 31-May-22 | 30 | 40 | 1200 |
The sum of the total costs | 19520 |
The sums of the total Costs would be (Here 19520 or any Number greater than 10000)
I just want to put the sums of the total Costs in the cell. All cells are counted automatically according to the laws define below:-
Random Value of Cost per capita, not less than 30 and not more than 40;
Random Value of Guest must not be less than 20 and not more than 50;
Random Value of Total Cost must not be friction value, should be the whole number;
Random Value of Total Cost must not be less than 700;
The Date value should not be on the weekly days.
Please Guys, Could it be possible on your part I shall be ever grateful.
Jun 01 2022 12:18 PM
If you're on 365 with access to LAMBDA this might work. Please see attached.