Community

1

I am trying to create a formula that assigns "Yes" to a cell if a result is within range and "No" if it is not.  This formula worked for only one of the columns in the range:

=IF([High Control Result]1 > [High Control Range Minimum]1, "Yes", "No")

I tried to use AND without success:

These formulas

1

Dear All,

I have a quite a large program plan. To have a level one plan, I have a column with a check box to indicate what needs to be shown in the Level 1 plan.

On filtering the Checkbox the Gnatt Chart view shows the dependency links, however when I export the same to PDF view the dependency links

1

Good morning all,

 

I am trying to create a formula that essentially does a planned budget value - actual budget value to get the "budget variance" but only if there is a number in the actual budget field. Any suggestions? Right now it is only:


=[Budget Planned]26 - [Budget Actual]26

 

But when we