In a cell on Sheet2 enter this formula then drag/copy down

=Sheet1!A1 + (LOOKUP(Sheet1!A1,{0,250,750,1500},{10,20,30,40}))

I am assuming the 1495 is a typo, otherwise what to do if 1496 to 1500


Gord Dibben MS Excel MVP


On Mon, 11 Feb 2008 12:45:14 -0800, S Swedowski
wrote:

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?