Thread: 6 cell sum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dc04wrightl dc04wrightl is offline
external usenet poster
 
Posts: 12
Default 6 cell sum

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