Hi

One way, without IF statements
=1+(A4<1000001)*0.25+(A4<250001)*0.25+(A4<125001)* 0.25+(A4<75001)*0.25
Regards

Roger Govier


mmr wrote:
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