Formula/Calculation Help?

[andruolson]

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

[Ocean West]

Automatic message

This topic has been moved from "Community Resources → Articles, Tips, Techniques & Solutions" to "Brain Food → The Left Brain".

[comment]

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.

[Matthew F]

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.