I have three conditions

A) If the product price is equal to or less than $100 divide by 52

B) If the product price is equal to or more than $101 but equal to or less than $500 divide by 250

C) If the product price is equal to or more than $501 divide by 500

I have achieved (A) plus (B) with =IF(L13<=100,L13/52,IF(L13>=101,L13/250)) but cannot get the third condition (C) to work.

I have tried =IF(L13<=100,L13/52,IF(L13>=101,L13/250,IF(L13>=501,L13/500)))

If you enter 50 (condition A) the answer given is, correctly, $0.96 (50/52)

If you enter 150 (condition B) the answer given is, correctly, $0.60 (150/250)

But 1,500 (condition C) the answer given is $6.00, double the $3.00 of the correct answer (1500/500)

Help!