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?

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 ; )

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.

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?

For PriceWholeSale

If jobberprice has something in it use that

if jobberprice is empty use value in JobberPriceMarkup

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

Case ( IsEmpty ( jobberprice ) ; JobberPriceMarkup ; jobberprice )