Calculating different values

J

JJM810

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.
 
S

Sandy Mann

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

[email protected]
[email protected] with @tiscali.co.uk
 
Top