Formulas

[Caroline1320]

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

[#2]

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

[#3]

@Riny_van_Eekelen 

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!

[#4]

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