Please help me on this....

[jasonkjyap]

I am quite new to excel VB.

Please help me on the below situation:

I have a list of date where they are category into A and B in the same
sheet(they arranged not according to the catogary).
I need to do some calculation if the data is belong to A and another
calculation if the data belongs to B. I try to use the funciton IF and
AND but can't really works.

All the experts please help!!!
or email me at (e-mail address removed)

Thank you!!!

 

[Otto Moehrbach]

Jason
Your problem is entirely too open-ended. There is nothing to work with.
Give some examples of what you have, and tell us what you want to do with
it. Please don't send a file to the newsgroup. Just explain. HTH Otto

 

[Rob van Gelder]

Assuming Column A is Category and Data is Column B:

Formula in C1:
=IF(A1="A", B1 * 2, IF(A1="B", B1 * 5, B1))

 

[jasonkjyap]

I am doing a soccer team reocrd where

colum A = Home or Away for the team
colum B = Home scoring
colum C = Away scoring
colum D = here is the formula where when i fill in the A, B, C then it
will appear "Home win" , "Away win" or "draw" for me.

But this formula needs to differentiate the Home and Away of the team.

I have came out with this formula but it's too long. Anyone to help me?
or can i write a VB to solve it?

=IF(AND(A="h",B>C),"HOME WIN", IF(AND(A="h",B<C),"AWAY
WIN",IF(AND(A="a",B>C),"HOME WIN",IF(AND(A="a",B>C),"AWAY
WIN","DRAW"))))

 

[Sharad]

IF you already have two seperate columns for Home score and Away Score,
Column A home or away is needless.

You can simply use following formula:

=IF(B1>C1,"HOME WIN",IF(B1<C1,"AWAYWIN","DRAW"))

Sharad