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
Caroline1320 Perhaps this?
=IF(I6="NO",I6*10/3,I6)The I6 at the end assumes that you want to return the value of I6 when it is not equal to NO.
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! |