Spreadsheet keeps track of steps to be completed in a phase of a project. As
each step is complete I want the system to return the % that step worth (1
out of 4 = 25%). I will total each % of each step complete to give me a
total of the phase completed. How do I create a formula for each step of the
phase that will return the %? I thought this should be as simple as saying:

IF C5 is not blank, return 25% (in cell D5). Please help.

Thank-you.

=(COUNTA(A1:D1))*0.25

where A1:D1 is your range of cells where the steps
completed are entered. This formula just counts non-
blank cell and multiplies that number by .25.

Let me know if this helps.



-----Original Message-----
Spreadsheet keeps track of steps to be completed in a
phase of a project. As
each step is complete I want the system to return the %
that step worth (1
out of 4 = 25%). I will total each % of each step
complete to give me a
total of the phase completed. How do I create a formula
for each step of the
phase that will return the %? I thought this should be
as simple as saying:

IF C5 is not blank, return 25% (in cell D5). Please
help.

Thank-you.
.

it is

=if(C5="","",25%)

--
Regards,
Tom Ogilvy

"mlatkovich" wrote in message
...
Spreadsheet keeps track of steps to be completed in a phase of a project.
As
each step is complete I want the system to return the % that step worth (1
out of 4 = 25%). I will total each % of each step complete to give me a
total of the phase completed. How do I create a formula for each step of
the
phase that will return the %? I thought this should be as simple as
saying:

IF C5 is not blank, return 25% (in cell D5). Please help.

Thank-you.

That's it! Thank-you!

"Tim" wrote:


=(COUNTA(A1:D1))*0.25

where A1:D1 is your range of cells where the steps
completed are entered. This formula just counts non-
blank cell and multiplies that number by .25.

Let me know if this helps.



-----Original Message-----
Spreadsheet keeps track of steps to be completed in a
phase of a project. As
each step is complete I want the system to return the %
that step worth (1
out of 4 = 25%). I will total each % of each step
complete to give me a
total of the phase completed. How do I create a formula
for each step of the
phase that will return the %? I thought this should be
as simple as saying:

IF C5 is not blank, return 25% (in cell D5). Please
help.

Thank-you.
.

Great! I knew it was simple. It was the "Non-blank" that I kept getting
stuck on. It works. Thanks!

"Tom Ogilvy" wrote:

it is

=if(C5="","",25%)

--
Regards,
Tom Ogilvy

"mlatkovich" wrote in message
...
Spreadsheet keeps track of steps to be completed in a phase of a project.
As
each step is complete I want the system to return the % that step worth (1
out of 4 = 25%). I will total each % of each step complete to give me a
total of the phase completed. How do I create a formula for each step of
the
phase that will return the %? I thought this should be as simple as
saying:

IF C5 is not blank, return 25% (in cell D5). Please help.

Thank-you.