Forum Discussion
AdamKeever1
Qrew Commander
Try this Anna:
------------------------------
Adam Keever
------------------------------
If( [Estimate Cost]=0,null, [Estimate Cost]<=500,100, [Estimate Cost]>500 and [Estimate Cost]<=1000,150, [Estimate Cost]>1000 and [Estimate Cost]<=3000,250, [Estimate Cost]*0.12)
[Estimate Cost] needs to be numeric and the formula field needs to be formula numeric.
------------------------------
Adam Keever
------------------------------
AnnaHarris
5 years agoQrew Trainee
That makes sense until the percentage. So as a breakdown:
My fee is as follows:
499.99 and under fee is 100.00
500.00 - 999.99 fee is 150.00
1000.00 - 2999.99 fee is 250.00
3000.00 + fees will be 12 % (ie: 3000.00 fee is 360.00 and so on...)
But the way this is written looks like it will add 12% to everything? or will this only add 12% to anything that does not fit in the prior statements??
------------------------------
Anna Harris
------------------------------
My fee is as follows:
499.99 and under fee is 100.00
500.00 - 999.99 fee is 150.00
1000.00 - 2999.99 fee is 250.00
3000.00 + fees will be 12 % (ie: 3000.00 fee is 360.00 and so on...)
But the way this is written looks like it will add 12% to everything? or will this only add 12% to anything that does not fit in the prior statements??
------------------------------
Anna Harris
------------------------------
- AdamKeever15 years agoQrew CommanderTry this then. The last part of the if statement, [Estimate Cost]*0.12, covers anything that is equal or greater than 3000.
If( [Estimate Cost]=0,null, [Estimate Cost]<500,100, [Estimate Cost]>=500 and [Estimate Cost]<1000,150, [Estimate Cost]>=1000 and [Estimate Cost]<3000,250, [Estimate Cost]*0.12)
------------------------------
Adam Keever
------------------------------- AdamKeever15 years agoQrew Commander
------------------------------
Adam Keever
------------------------------- AnnaHarris5 years agoQrew TraineeToday your a hero Adam!!! Thanks for your help! It worked perfect!
------------------------------
Anna Harris
------------------------------