Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating different values
Could anyone tell me how to make several rows in my worksheet hold different
values? First category would count as 1.5, the next might count as .50, the next might count as one. My spreadsheet tracks productivity and one activity may be more complex than the next. -- jjm810 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating different values
I don't really understand your question but I would guess that you are
looking for something like: IF(First category,COUNT(Range)*1.5,IF(Second category,COUNT(Range)*0.5,IF(Third category,COUNT(Range)))) -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "JJM810" wrote in message ... Could anyone tell me how to make several rows in my worksheet hold different values? First category would count as 1.5, the next might count as .50, the next might count as one. My spreadsheet tracks productivity and one activity may be more complex than the next. -- jjm810 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
calculating commissions for a range of values | Excel Worksheet Functions | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
View of x-axis values | Charts and Charting in Excel |