If statement

[Guest]

Help!! I need a formula that will display the number of credits earned (1
per $500 of sales) in increments of $500 with a minimum purchase of
$500...for example, $750 worth of sales = 1 credit, $1000 sales = 2 credits
and so on...

 

[Peo Sjoblom]

=FLOOR(Sales/500,1)


--


Regards,


Peo Sjoblom

 

[Don Guillett]

=IF(B14>=500,INT(B14/500),"")