Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formulas using text
hello
First i dont even know is this is possible orif i am using the right program but...i would like to set excell for a football pool where each players pick is matched against the outcome of that game and will enter the value win or loss i used the formula =IF(AND(D2=B2,D2<C2),"win","loss") but its not error proof also i would like a function add up all the win and losses to get a win loss record for that week i.e. 11-5 if thats possible you are a god and i am the happiest person alive -- bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show text after formulas | Excel Discussion (Misc queries) | |||
How do I convert cells containing formulas to text (value returned | Excel Worksheet Functions | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
How do you average text formulas?? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |