Prev: Vacation Tracking formula
Next: Future date with six day week including holidays
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 A-1 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 follow-up 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 follow-up 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 A-1 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