Jump to content
• Sign Up

# Formula/Calculation Help?

## Recommended Posts

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

#### Share this post

##### Share on other sites

Automatic message

This topic has been moved from "Community ResourcesArticles, Tips, Techniques & Solutions" to "Brain FoodThe Left Brain".

#### Share this post

##### Share on other sites

This seems to be a duplicate post:

http://fmforums.com/forum/topic/85637-product-pricing-calculations/

In any case, the question is not clear.

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

That's not even a sentence.

#### Share this post

##### Share on other sites

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

Ha ha. That makes no sense to me either. Besides, I thought the answer to the universe is 42.

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×

×
×
• Create New...

## Important Information

By using this site, you agree to our Terms of Use.