Help with if statements

[Steven1337]

I dont know if this is possible and I am very new to if statements in filemaker but here is kind of what I am looking for:

I have a field called FinalPrice which has the final retail price for all the products in my database that have been manually put in.

I am also using this field to display the price for the products on my website. I want to change this field to a calculated value which depends on another field(jobberprice) being filled up.

So basically the if statement in pseudo code would be:

if jobberprice has content in it perform a calculation

if jobber price is empty leave finalprice as is (do nothing)

Is something like this even be possible?

[comment]

If the FinalPrice stores an entered value, then it cannot calculate another without losing the stored one. You can use a third field, a calculation =

Case ( IsEmpty ( jobberprice ) ; FinalPrice ; )

[Steven1337]

You have given me a good idea I am going to try something different.

My FinalPrice field will now depend on the Calculation PriceWholesale * Markup

Mark up being 1.35

PriceWholeSale will be where I need my if statement.It would Either be the value In JobberPrice Or JobberPriceMarkup Depending if JobberPrice is Empty.

So If JobberPrice is Empty I want to use the field JobberPriceMarkup

which I think would go something like this

Case ( IsEmpty ( jobberprice ) ; jobberprice ; jobberpricemarkup )

Argh. Thats Probably wrong but i think it would be something like that I am very new with working with cases.

[comment]

It would be easier if you explained the real logic behind this and leave the calculations out. IOW, how would you do it using pencil and paper?

[Steven1337]

For PriceWholeSale

If jobberprice has something in it use that

if jobberprice is empty use value in JobberPriceMarkup

[comment]

Well, that's practically the same thing as before:

Case ( IsEmpty ( jobberprice ) ; JobberPriceMarkup ; jobberprice )