Forum Discussion
AustinK
Qrew Commander
Best bet to get quicker help is to post the actual formula as text so people can copy and paste it. Also is this a text field? I am guessing text as the numbers have quotes around them but it would be good to know for sure.
With an offhand guess I would wrap the yellow text in a ToText function.
With an offhand guess I would wrap the yellow text in a ToText function.
AnnaHarris
5 years agoQrew Trainee
Formula:
If([Estimate Cost]<=500,"100.00",[Estimate Cost]>=500,"150.00",[Estimate Cost]>=1000, "250.00",[Estimate Cost]>=3000,[Estimate Cost] *.12)
------------------------------
Anna Harris
------------------------------
If([Estimate Cost]<=500,"100.00",[Estimate Cost]>=500,"150.00",[Estimate Cost]>=1000, "250.00",[Estimate Cost]>=3000,[Estimate Cost] *.12)
------------------------------
Anna Harris
------------------------------
- AdamKeever15 years agoQrew CommanderTry this Anna:
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
------------------------------- AnnaHarris5 years agoQrew TraineeThat 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
------------------------------- 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
------------------------------