| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automate point system
I have seconds in column as reference ie: A1 = 00:00:06 -- I have to make
formula in which if a1<00:00:07 then cell =5 (round number) otherwise if cell a100:00:07 but <00:00:14 then sum of cell =3 or if cell a100:00:14<00:00:25 then cell =2 or if cell a100:00:25 then cell =0 (tried several functions but keep on getting error) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a "Point System" Spreadsheet | Excel Discussion (Misc queries) | |||
| Data point on line is not over the point/tick in X axis... | Charts and Charting in Excel | |||
| X Y Scatter With Point name on each point ? | Charts and Charting in Excel | |||
| I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
| excel causing system to be in low system resource | Excel Discussion (Misc queries) | |||
Linear Mode
