IF then Else function usage in Excel 2007

Hi All,

I need help in terms of usage of which funtion formula to do the following.

I have an excel sheet in which i would like to use the 'IF' funtion and then by formatting arrive at the values in the cell, say if the value of a particular cell is > 3 then the cell in which we are putting the formula should read as Fast Moving. Similarly if the value is between >1 and < 3 then it should read as Slow moving and if the value is less than 1 it should read as slow moving.

Can someone help me with the function to be used to solve this.

Thanks in advance.

Regards

Mathew

Matthew

There are some contradictions in your criteria, e.g you have >3 and <3. What happens if it is 3? I have allowed for some of these but anything over 1 will get a proper case Slow Moving and anything below or equal to 1 will get an all lower case 'slow moving'. (That would be too subtle a difference for me!)

I have also allowed the first clause to show nothing if the cell it relies on is blank.

=IF(A1="","",IF(A1>=3,"Fast Moving",IF(A1>1,"Slow Moving","slow moving")))

Perhaps youmean

=IF(A1="","",IF(A1>=3,"Fast ",IF(A1>=1,"","Slow ")))&"Moving"

Thanks for the responses. To make your understanding more clear, when it meets the below crieterias i want the answers as below.
 
Crieteria   Category
>=3Fast    Moving
>1<=2      Slow Moving
<=0         Non Moving

=IF(A1="","",IF(A1>=3,"Fast ",IF(A1>=1,"Slow ","Non-")))&"Moving"

thanks. it worked.

Regards
Mathew

Hello! My problem is similar to Mathews although I'm not sure the same formula will work... The calculation concerns two people running after each other, one starting from a further horizontal distance... I would need my excell spreadsheet to do this:

If person B's horizontal position = to person A's horizontal position and person B's vertical position is >= to person A's vertical position, the box should display "gone past him". If person B's horizontal position = to person A's horizontal position and person B's vertical position is <= to person A's vertical position, the box should display "catching up to him". If person B's horizontal position > to person A's horizontal position and person B's vertical position is <= to person A's vertical position, it should display "approaching".

Is this possible? Thank you!

I have this IF - THEN question.  Is it possible to write an IF statement that would take information and add it to the first blank space in a column?  For instance:  IF there is an "X" in A5, take the information in B5 and put it in the first blank cell in column A in Worksheet 2, then have that same function for other "A" cells in the worksheet that would continue to add to that list.

So start your own thread for your question, don't hijack another.