10

Happy Friday All:

I am trying to replace IF Formula with IFERROR so I do not receive #DIVIDE BY ZERRO Error. However, I receive Incorrect when I use the IFERROR. Can anyone help?

Existing Formula:

=IF(AND(TODAY() >= [Start Date (Planned)]18, TODAY() <= [Finish Date (Planned)]18), ROUND(NETWORKDAYS([Start Date (Planned)]18, TODAY()) / Duration18, 2), IF(TODAY() > [Finish Date (Planned)]18, 1, 0))

 

Attempted Formula:

=IFERROR(AND(TODAY() >= [Start Date (Planned)]18, TODAY() <= [Finish Date (Planned)]18), ROUND(NETWORKDAYS([Start Date (Planned)]18, TODAY()) / Duration18, 2), IF(TODAY() > [Finish Date (Planned)]18, 1, 0))

 

Thanks

 

 

 

Comments

You are missing the beginning IF statement. When using an IFERROR like this, you want to wrap the entire original formula.

 

=IFERROR(original formula without the beginning =, output if error)

I try that and I received an error as well, Incorrect. I ma not sure I understand original formula without the beginning =, output if error

 

=IFERROR(AND(TODAY() >= [Start Date (Planned)]11, TODAY() <= [Finish Date (Planned)]11), ROUND(NETWORKDAYS([Start Date (Planned)]11, TODAY()) / Duration11, 2), IF(TODAY() > [Finish Date (Planned)]11, 1, 0))

Andree_Stara

In reply to by Ray B

Hi Ray,

It looks like you missed the IF function in the start.

Try something like this.

=IFERROR(IF(AND(TODAY() >= [Start Date (Planned)]18, TODAY() <= [Finish Date (Planned)]18), ROUND(NETWORKDAYS([Start Date (Planned)]18, TODAY()) / Duration18, 2), IF(TODAY() > [Finish Date (Planned)]18, 1, 0)))

Did it work?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

work-bold

In reply to by Ray B

Taking a closer look at the formula, we are not actually filling in the second portion of the IFERROR statement.

 

We have:

 

=IFERROR(

 

               IF(............, .............., IF(............., ..............., .............)))

.

We should have

 

=IFERROR(

 

               IF(............, .............., IF(............., ..............., .............))

       ...............)

.

Try this one...

 

=IFERROR(IF(AND(TODAY() >= [Start Date (Planned)]18, TODAY() <= [Finish Date (Planned)]18), ROUND(NETWORKDAYS([Start Date (Planned)]18, TODAY()) / Duration18, 2), IF(TODAY() > [Finish Date (Planned)]18, 1)), 0)

In reply to by Ray B

Andree is correct. Basically that initial = is letting Smartsheet know that you are entering a formula.

 

So you would start with the =.

 

=

 

Then begin your formula

 

IFERROR(IF(AND(...............................