Skip to main content

If checkbox V --> calculate price of 2 column

  • October 23, 2022
  • 2 replies
  • 36 views

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 !

2 replies

Forum|alt.badge.img+5
  • Participating Frequently
  • October 23, 2022

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:


  • Author
  • New Participant
  • October 23, 2022

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 !