Skip to main content

Hi, I’m trying to make a formula if a checkbox is tiped:

If checkbox is tiped than calculate the price by multiplying a value in column A by another value in columbn B and show the result in column C.


I could have something but the result shown was “error” when the checkbox was untiped…


Thanks a lot for your help !

Hey @Karim_Younan!


Here’s a quick formula that appears to fit your requirements.


IF(

  {Checkbox},

  ({Initial Value} * {Value To Multiply By})

)

Here’s a look at the formula’s behavior:


Hey @Karim_Younan!


Here’s a quick formula that appears to fit your requirements.


IF(

  {Checkbox},

  ({Initial Value} * {Value To Multiply By})

)

Here’s a look at the formula’s behavior:



Great, thanks a lot !

Reply


Terms & Conditions