Hello,

maybe some test values help you to decide which formula to take:

macropod Biff_1 Biff_2 Avri_mod Bernd
-1 5000 #N/A #N/A 5000
199999 5000 5000 5000 5000 5000
199999.99 10000 5000 5000 5000 5000
200000 10000 10000 10000 10000 10000
499999 10000 10000 10000 10000 10000
499999.99 15000 10000 10000 10000 10000
500000 15000 15000 15000 15000 15000
1.00E+300 15000 15000 15000 15000 15000

macropod =IF(C8<=199999,5000,IF(C8<=499999,10000,15000))
Biff_1 =LOOKUP(C8,{0,1,200000,500000},{"",5000,10000,1500 0})
Biff_2 =IF(C8=500000,15000,IF(C8=200000,10000,IF(C80,5 000,"")))
Avri_mod =5000*MATCH(C8/1000,{0;200;500},1)
Bernd =LOOKUP(C8,{-1E+300,200000,500000},{5000,10000,15000})

Regards,
Bernd