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
3 Replies
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! 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.
