In article , TLAX wrote:

When the value of a cell is less than or equal to 550 the value in
another cell should be 1, greater than 550 but less than or equal to
1100 the value in another cell should be 2, greater than 1100 but less
than or equal to 1650. Pleae provide a for formula for this

... what do you think it should be ? :)

If you have a go, people are more likely to help.