I have a sheet that will a tick box in column J. When another tick box is ticked in column E I would like the sheet to check if column J has a tick in it and if so insert the value of 1.5 into column F. If the tick box in J is unticked I would like the value of 3 to go into column F instead. I have been trying to write this myself and failing so I thought I would ask the experts.


=IF(J1=TRUE, IF(E1=TRUE, 1.5, 3), )

or perhaps:

=IF(E1=TRUE, IF(J1=TRUE, 1.5, 3), )


  • 1
    Petrect! Thank you so much – ceolnamara Apr 29 '19 at 14:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.