Worksheet for team Comparison (Testing a Text Value)

  • Thread starter Thread starter Nasir Khan
  • Start date Start date
N

Nasir Khan

Hello all,
I am trying to create a worksheet as follows giving points for two Teams:

A B C D E
F G ........these are columns

TEAM TEAM PointsUp PointsAgainst Criteria (U or A) FormulaA
FormulaB
A B 10 0.70 U
=Test Criteria =Test Criteria

if 'U' then PointsUp* if 'A' then value in

PointAgainst Points Up

(eg 10 * 0.70 (eg 10 in this example)

in this example)

I have given an example of the worksheet I am trying to create. I need help
with FormulaA and FormulaB.
I searched the group with related heads like IF testing against a TEXT value
etc.. but could not find a suitable one for my requirement.

Any help would be appreciated.


TIA


Nasir Khan
 
If I understand your question then:
enter in F2 =IF(E2="u",C2,"")
enter in G2 =IF(E2="a",(C2*D2),"")

Charlie O'Neill
 
Thanks Charlie,
Your formula does not work. If u wish I can mail u my worksheet

Nasir
 
Back
Top