AnsweredAssumed Answered

Formula/Calculation Help

Question asked by AndrewOlson on Aug 9, 2012
Latest reply on Aug 9, 2012 by schamblee


Formula/Calculation Help


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