2 Replies Latest reply on Aug 9, 2012 5:32 PM by schamblee

    Formula/Calculation Help

    AndrewOlson

      Title

      Formula/Calculation Help

      Post

      Hey, can anyone help me with a formula? should be super simple... I just can't seem to write it out so FileMaker understands it..

      Basically have just a few different variables..

       

      Window Count = W

      House Level = L

      Base Price = Bp (Starts at $25.00)

      Exterior Price = Ep (= $2.00)

      Interior Price = Ip

       

      Forumla i'm trying to write is kind of as follows... 

       

      If L is less than 2 then use Bp & Ep and then divide the W by 3 times it by (Ep x 3)....

      If the W=12 in this paticular situation, then the answer would = $49.00

       

       

      Can someone help me write this forumla to make since within FileMaker.. Like I said I don't think it would be that hard, yet im' struggling pretty bad.. ANY help would be most appreciated! thanks all

       

        • 1. Re: Formula/Calculation Help
          davidanders

          I have a one level house the BasePrice is always $25

          I have 10 windows for each window I will charge the Interior Price ??

          If I do the exterior of the 10 windows I will charge $2 each or $20 total

          I want to add the base price...

          Sorry, I went through calculus and am having problems parsing your process. Step by step would help.
          Always had problems with the word exercises (two trains leave...)

          • 2. Re: Formula/Calculation Help
            schamblee

            (W/3)*(Ep*3)+Bp  would be your calculation.   You didn't state what would be done if L was 2 or more and you didn't give any info about lp.