I want a non-blank cell to return 25% in an adjacent cell.
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.
|