Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement formula
Hi
Im hoping someone can assist me in creating a formula that does the following. I would like it to look at a cell, and that cell contains a number greater that 120, to return a figure of 10 for each increment of 30 over 120. For instance, if the cell contained 121 it would return '10'. If the cell contained 211 it would return '40' etc. Any ideas? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement formula
Hi
Try =IF(A1<120,"",10+(INT((A1-120)/30)*10)) -- Regards Roger Govier "JaB" wrote in message ... Hi Im hoping someone can assist me in creating a formula that does the following. I would like it to look at a cell, and that cell contains a number greater that 120, to return a figure of 10 for each increment of 30 over 120. For instance, if the cell contained 121 it would return '10'. If the cell contained 211 it would return '40' etc. Any ideas? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement formula
=(INT((A1-120)/30)+1)*10
But what should the formula return if A1<=120 or it's not a number at all? Regards, Stefi €˛JaB€¯ ezt Ć*rta: Hi Im hoping someone can assist me in creating a formula that does the following. I would like it to look at a cell, and that cell contains a number greater that 120, to return a figure of 10 for each increment of 30 over 120. For instance, if the cell contained 121 it would return '10'. If the cell contained 211 it would return '40' etc. Any ideas? Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement formula
Thanks Roger, Stefi.
If its = to 120 or less I want it to return a zero value. "Stefi" wrote: =(INT((A1-120)/30)+1)*10 But what should the formula return if A1<=120 or it's not a number at all? Regards, Stefi €˛JaB€¯ ezt Ć*rta: Hi Im hoping someone can assist me in creating a formula that does the following. I would like it to look at a cell, and that cell contains a number greater that 120, to return a figure of 10 for each increment of 30 over 120. For instance, if the cell contained 121 it would return '10'. If the cell contained 211 it would return '40' etc. Any ideas? Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement formula
Hi
Then replace my double quotes with a zero =IF(A1<120,0,10+(INT((A1-120)/30)*10)) -- Regards Roger Govier "JaB" wrote in message ... Thanks Roger, Stefi. If its = to 120 or less I want it to return a zero value. "Stefi" wrote: =(INT((A1-120)/30)+1)*10 But what should the formula return if A1<=120 or it's not a number at all? Regards, Stefi "JaB" ezt ķrta: Hi Im hoping someone can assist me in creating a formula that does the following. I would like it to look at a cell, and that cell contains a number greater that 120, to return a figure of 10 for each increment of 30 over 120. For instance, if the cell contained 121 it would return '10'. If the cell contained 211 it would return '40' etc. Any ideas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
if date statement or formula | Excel Discussion (Misc queries) | |||
IF statement when formula result is blank | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
=IF Statement formula or conditional formatting | Excel Worksheet Functions |