View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

=2-(0.25*(MATCH(A4,{0,75002,125002,250002,1000001},1)-1))

--
HTH

Bob Phillips

"mmr" wrote in message
...
Can you create an if statement for me?

If a4=<75,001 fee=2.00
if a4=75,001 but <125001 fee=1.75
if a4=125001 but<250001 fee=1.50
if a4=250001 but<1000001 fee=1.25
if a4=1000001 fee=1.00