From: cccc on 7 Mar 2010 20:00 I am really sorry I have left msg here a week ago but I can not find it now. I found out what I need to do. Here is example A B C D 1 222 333 343 OK if I put 1 in A1 it is going to show above for columns B, C, and D If I put 2 in A different numbers will show and so on for 6 categories. Now if it is 2 and in be for wxample should be 454, in A 12 should put them in categories. Category 1 (if A=1 B=222) should say Category 1, if it is 332 It is still category1. Here is my formula =IF(B27>1109,"Category 1",IF(B27>800,"Category 2",IF(B27>0,"Category 3",""))) this is only if A1 but for A=2 it should be =IF(B27>1300,"Category 1",IF(B27>200,"Category 2",IF(B27>0,"Category 3",""))) and so on for 6 different categories But for example A=2 B=454 it should be Category 1 also for example. So how do I make it say Instead Category 2 Category 1?
From: Joe User on 7 Mar 2010 20:41 "cccc" wrote: > I am really sorry I have left msg here a week > ago but I can not find it now. If you are referring to your thead "What function to use" dated 2/28/2010, click on your name in this thread, then click "Recent Posts" in the upper right corner of the User Profile window. In the future, you might find your recent postings by clicking the "Edit my Profile" icon next to Help in the upper right of the Discussion Group window, then clicking the Preview button near the bottom. That opens a User Profile window. At this point, it is up to you to decide wheter to continue with this new thread, or to repost your new inquiry as a followup in the original thread. The original context might be helpful to potential respondents. If you do the latter, it would be prudent to post a followup to this thread, redirecting everyone to your first thread.  original message  "cccc" wrote: > I am really sorry I have left msg here a week ago but I can not find it now. > I found out what I need to do. > Here is example > A B C D > 1 222 333 343 > OK if I put 1 in A1 it is going to show above for columns B, C, and D > If I put 2 in A different numbers will show and so on for 6 categories. > Now if it is 2 and in be for wxample should be 454, in A 12 should put them > in categories. Category 1 (if A=1 B=222) should say Category 1, if it is 332 > It is still category1. > Here is my formula =IF(B27>1109,"Category 1",IF(B27>800,"Category > 2",IF(B27>0,"Category 3",""))) this is only if A1 but for A=2 it should be > =IF(B27>1300,"Category 1",IF(B27>200,"Category 2",IF(B27>0,"Category 3",""))) > and so on for 6 different categories > But for example A=2 B=454 it should be Category 1 also for example. So how > do I make it say Instead Category 2 Category 1? >
From: cccc on 7 Mar 2010 23:00 Yes that is my original post I really did not know how to do it. I have asked for more directions that is why I have wrote this topic

Pages: 1 Prev: Vacation Tracking formula Next: Future date with six day week including holidays 