Forum Discussion
Formulas
Could someone help please. I need to write a formula that will work for: If I6 = NO then H6 needs to be divided by 3 and then *10 I have tried this but get error of "Value" Thanks
Thank you for your help. Unfortunately this hasn't worked.
| ü | ACORN ROOM 1 | DOB | Sex | Age | Funding Form Received | Total Number of Hours | Funded | Entitlement for two year olds | ||||||
| Number of Hours (15/30) | Additional Hours To Pay Per Week | Staying all Day (including Lunch) | Lunchtime Payment | Total Payable per week | Amount to Pay | |||||||||
| 1 | Test | Test | 26/09/2018 | F | 4 | 21 | Yes | 15 | £20.00 | Yes | £2.00 | £22.00 | ||
| 2 | Ronald | McDonald | 05/02/2019 | M | 3 | 30 | Yes | 30 | £0.00 | Yes | £0.00 | £0.00 | ||
| 3 | Minnie | Mouse | 14/06/2020 | F | 2 | 21 | yes | 15 | £20.00 | Yes | £1.00 | £21.00 | ||
| 4 | Mickey | Mouse | 14/06/2020 | M | 2 | 9 | No | 30 | #VALUE! | No | £0.00 | #VALUE! |
Caroline1320 Better to upload or share link to the file (OneDrive or alike), because there isn't much to do with the table you pasted.