Ok, I am drawing a blank today. I don't work with Excel dailey anymore.
I have 2 sheets. Sheet A and Sheet B. Sheet A has numbers in it and I want
to transfer the numbers to Sheet B using the IF Function because if the
numbers a
for example
less than 249, add 10
if the number is between 250 and 749 add 20
if the number is between 750 amd 1495 add 30
if number is greater than 1500 add 40

I know this is easy, but I just can't get the right syntax. Can someone help?