6 cell sum

  • Thread starter Thread starter dc04wrightl
  • Start date Start date
D

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
 
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
Click to expand...

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.
 
Back
Top