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