Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formulas
I need to know how I would write the formula for this function, if anyone
could help me that would be wonderful If a number in a cell is between 1-15 then I need it in another cell to only equal 1, if the number is between 16-30 I need it to equal 2, if the number is 31-45 I need it to equal 3, if the number is 46-60 I need it to equal 4, if the number is between 61-75 I need it to equal 5, so on and so fourth. These are 15 minutes increments of time. hard to explain, but in one cell will be the time in minutes for example 18 minutes, in another cell will be number that is a base unit for example 5. I need the number in the third cell to be the base number of units which is 5, and the time units from the other cell which since it is 18 would actually equal two time units, so 18=2, then the total number in the third cell will be 7 (5+2=7), but I need the spreadsheet to calculate the Time minutes of 18 into two units of time. Can anyone help me with this one is seems complicated. Thank you so much |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formulas | Excel Discussion (Misc queries) | |||
if and conditional formulas | Excel Worksheet Functions | |||
Conditional Formulas | Excel Discussion (Misc queries) | |||
conditional formulas | Excel Worksheet Functions | |||
Conditional formulas with sum and if | Excel Discussion (Misc queries) |