Formulas

New Contributor

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.

@Riny_van_Eekelen 

 

Thank you for your help. Unfortunately this hasn't worked. 

 

 

üACORN ROOM 1DOBSexAgeFunding Form ReceivedTotal Number of HoursFunded    Entitlement for two year olds
         Number of Hours (15/30)Additional Hours To Pay Per WeekStaying all Day (including Lunch)Lunchtime PaymentTotal Payable per weekAmount to Pay
1TestTest26/09/2018F421Yes15£20.00Yes£2.00£22.00 
2RonaldMcDonald05/02/2019M330Yes30£0.00Yes£0.00£0.00 
3MinnieMouse14/06/2020F221yes15£20.00Yes£1.00£21.00 
4MickeyMouse14/06/2020M29No30#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.