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

# Formula/Calculation Help

### 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

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

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