IF Function

  • Thread starter Thread starter S Swedowski
  • Start date Start date
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?
 
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested IF Function 4
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
adding sheets 2
Excel Formula or equation 3
Macro To Delete/Add & Rename/Arrange Sheets 5
problem with fractions to decimal 1
Excel How to Autocomplete text/string within a single cell, between different worksheets 1

Back
Top