Nov 04 2022 05:50 AM
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
Nov 04 2022 06:35 AM
@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.
Nov 04 2022 07:04 AM
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! |
Nov 04 2022 07:34 AM - edited Nov 04 2022 07:35 AM
@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.