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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 07:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com