Copper 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" 



3 Replies

@Caroline1320 Perhaps this?


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

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