samarmalik71

Thank you for the solution.

Thank you for time and efforts you are putting to solve the queries of the peopele like me.
There is a one more question. I am setting up the price range and commission range as well. Like, if the price in fieldname1 is less than 250, the commission would be (60+(fieldname1*0.10)). If, the price is in betweeen 250-500, the commission would be (60+(fieldname1*0.20)). And, if the price is in between 500-1000, the commission would be (60+(fieldname1*0.30)). Is it possible to make a formula for this???

Hey,
please help me with an another issue. I prepared this formula with the help of your. But, on the Preview page or webpage, the result of this generala calculation is showing already before entering the value of fieldname2.

(function(){
if(AND(fieldname6 == ‘Paperback’, fieldname7 == ‘5″ X 8″‘, fieldname8 == ‘Black & White’)) return PREC(fieldname2*0.8-(fieldname2-100)*0.35, );
})()

I am getting, 35 as the value in the result box before entering any value for fieldname2. What I want is to hide 35 from the tab or place 0 instead.
Here is the link,
Link

Thanks. You are a jem.