# Formulas

Copper Contributor

# 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

# Re: Formulas

@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.

# Re: Formulas

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!

# Re: Formulas

@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.