| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
compare cell a1 & b1. if dig 1<2 ina1 &dig 1<2 in b1 then val = 1
on excel w/s
Chelsea 10 Charlton 10 3 AstonVilla 12 ManCity 22 chk Blackburn 13 Fulham 31 chk CrystalPal 22 Southpton 23 chk using IF fx, I know how to give 3 points to the win. want to also be able to score the win = 1 point and the loss = 0 points. need to compare dig values in a cell in relation to digit values in other cells and give it a value ??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
