6 cell sum

[dc04wrightl]

Hi,
I need a formula or a mathematic help. Basicaly i have 6 cells. I need to
tell it to be
0.1 when 1 cell if filled in
0.2 when 2 cells are filled in
0.3 when 3 cell are filed in
0.4 when 4 cells are filled in
0.5 when 5 cells are filled in
and 1 when all of them are filled in

Thanks for your help
Lyndon

 

[Duke Carey]

=.1*counta(6 cell range) +.5*(counta(6 cell range)=6)

 

[RB]

Hi,
I need a formula or a mathematic help. Basicaly i have 6 cells. I need to
tell it to be
0.1 when 1 cell if filled in
0.2 when 2 cells are filled in
0.3 when 3 cell are filed in
0.4 when 4 cells are filled in
0.5 when 5 cells are filled in
and 1 when all of them are filled in

Thanks for your help
Lyndon

You could write this 2 ways:

1. A nested if statement: if cell A1= 1, then .1 etc.
2. a vlookup: you could have a separte array that refrences the cell
to that.
You may have to play around with the syntax but this is the basic
format.