| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
Hi. This may be something simple but Im not sure how to do it. I need a
formula where when value is greater than 5 but less than 8 = 0.5 and when is greater than 0 but less than 5 = 1 at the same time all the data is accumulating the points in cell A1. Thanks for the help -- Regards YM |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
=if(a15,.5,if(a10,1))
or =if(a18,"",if(a15,.5,if(a10,1))) -- Don Guillett Microsoft MVP Excel SalesAid Software "Yitzhack" wrote in message ... Hi. This may be something simple but Im not sure how to do it. I need a formula where when value is greater than 5 but less than 8 = 0.5 and when is greater than 0 but less than 5 = 1 at the same time all the data is accumulating the points in cell A1. Thanks for the help -- Regards YM |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
Thanks Don thats exactly what I needed. Just one more question. How do I
expand that to multiple rows? Thanks -- Regards YM "Don Guillett" wrote: =if(a15,.5,if(a10,1)) or =if(a18,"",if(a15,.5,if(a10,1))) -- Don Guillett Microsoft MVP Excel SalesAid Software "Yitzhack" wrote in message ... Hi. This may be something simple but Im not sure how to do it. I need a formula where when value is greater than 5 but less than 8 = 0.5 and when is greater than 0 but less than 5 = 1 at the same time all the data is accumulating the points in cell A1. Thanks for the help -- Regards YM |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
I'm sorry, i meant columns
-- Regards YM "Yitzhack" wrote: Hi. This may be something simple but Im not sure how to do it. I need a formula where when value is greater than 5 but less than 8 = 0.5 and when is greater than 0 but less than 5 = 1 at the same time all the data is accumulating the points in cell A1. Thanks for the help -- Regards YM |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
Perhaps
=(COUNTIF($A$1:$A$10,"0")-COUNTIF($A$1:$A$10,"=5"))+((COUNTIF($A$1:$A$10," =5")-COUNTIF($A$1:$A$10,"8"))/2) Extend the ranges to suit Mike "Yitzhack" wrote: I'm sorry, i meant columns -- Regards YM "Yitzhack" wrote: Hi. This may be something simple but Im not sure how to do it. I need a formula where when value is greater than 5 but less than 8 = 0.5 and when is greater than 0 but less than 5 = 1 at the same time all the data is accumulating the points in cell A1. Thanks for the help -- Regards YM |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
It looks like you want to exclude 8 so try this instead
=(COUNTIF($A$1:$A$10,"0")-COUNTIF($A$1:$A$10,"=5"))+((COUNTIF($A$1:$A$10," =5")-COUNTIF($A$1:$A$10,"=8"))/2) Mike "Mike H" wrote: Perhaps =(COUNTIF($A$1:$A$10,"0")-COUNTIF($A$1:$A$10,"=5"))+((COUNTIF($A$1:$A$10," =5")-COUNTIF($A$1:$A$10,"8"))/2) Extend the ranges to suit Mike "Yitzhack" wrote: I'm sorry, i meant columns -- Regards YM "Yitzhack" wrote: Hi. This may be something simple but Im not sure how to do it. I need a formula where when value is greater than 5 but less than 8 = 0.5 and when is greater than 0 but less than 5 = 1 at the same time all the data is accumulating the points in cell A1. Thanks for the help -- Regards YM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
