Functions and Formulas

Re: IF then Else function usage in Excel 2007

Bob Phillips — Wed, 12 Oct 2011 13:55:24 GMT

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

Re: IF then Else function usage in Excel 2007

Daniel — Mon, 10 Oct 2011 18:03:32 GMT

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.

Re: IF then Else function usage in Excel 2007

A. Dreamer — Thu, 15 Sep 2011 04:52:06 GMT

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!

Re: IF then Else function usage in Excel 2007

mathews.yohannan — Sat, 18 Oct 2008 07:16:30 GMT

thanks. it worked.

Regards
Mathew

Re: IF then Else function usage in Excel 2007

Bob Phillips — Fri, 17 Oct 2008 14:51:20 GMT

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

Re: IF then Else function usage in Excel 2007

mathews.yohannan — Fri, 17 Oct 2008 13:45:54 GMT

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

Re: IF then Else function usage in Excel 2007

Bob Phillips — Sat, 11 Oct 2008 17:56:32 GMT

Perhaps youmean

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

Re: IF then Else function usage in Excel 2007

Nick Hodge — Sat, 11 Oct 2008 10:20:15 GMT

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")))

IF then Else function usage in Excel 2007

mathews.yohannan — Sat, 11 Oct 2008 09:21:33 GMT

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