need help with a formula

need help with a formula

im trying to figure out an if statement for our counter tops, this is what it is now

=IF(Field_Joint_Qty>0,Field_Joint_1_Location,Width)

but lets say i want to deduct from the answer of above with,

IF(Left_Finish_End>0,-M!Base_Side_Finished_End_Thickness)

i can't seem to figure out how to write this one

thank you


    MVU eLearning



    Grow Your Knowledge
    Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.


      Follow us on:

               

        Google Review