Formula & Checkboxes

Hello All,

How would I go about adding to this formula if I wanted it to recognize a checkbox for instance?
(e.g. The staff member would tick the box and it would add on $200 to the total.)

TEXT(MULTIPLY({Order Value (EX GST)},{Freight Charge Percentage})+IF({Order Value (EX GST)}<1000,80,0),"$#,###")

I have tried adding on additional IF statements and it just keeps coming back with errors.


Hi Rhyno3000,

How about IF({Check},Formula + 200, Formula)?


1 Like