| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i make 0.6 = 1 in excel
I'm trying to produce averages for my local cricket team (UK) using Excel. On
occasions, a bowler does not complete an 'Over' so may end up with an entry of 7.3. On anther occasion, he has an entry of 6.4. Now, in normal addition 7.3 + 6.4 = 13.7, however in cricket there are only 6 balls in an over, so the total would be 14.1. Does anyone have ideas on a formular for this type of equation? Thanks Barfly |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make table query will work in datasheet view but will not make tab | Excel Discussion (Misc queries) | |||
| How do I make make comment format default? | Excel Discussion (Misc queries) | |||
| make macros usable! make instructions in plain english !!!! | Excel Worksheet Functions | |||
| Excel templates. Wanna make excel look like regular blue lined pap | Excel Discussion (Misc queries) | |||
| how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) | |||
Threaded Mode
