IF Function

S

S Swedowski

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 are:
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?
 
Y

Yanick

Here it is!

=IF(A1<=249,A1+10,IF(A1<=749,A1+20,IF(A1<=1499,A1+30,A1+40)))

Replace A1 with the cell you need.
 
S

S Swedowski

Perfect!! Thanks a million!!

Suz

Yanick said:
Here it is!

=IF(A1<=249,A1+10,IF(A1<=749,A1+20,IF(A1<=1499,A1+30,A1+40)))

Replace A1 with the cell you need.
Click to expand...
 
G

Gord Dibben

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
 
Top