Calculation within IF statement

12/15/21
Accepted

Hello,

I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVALID DATA TYPE" and I tried to use to IF statement to do that - If completion date is blank, leave the cell blank, otherwise compute the variance:

=IF(ISBLANK([Completion Date]@row), "", =NETDAYS([Request Date]@row, [Completion Date]@row))

This returns "#INVALID OPERATION" on the whole column. I've tried the =IF(NOT(ISBLANK variation with the same result. Is there a way to include formulas within an IF statement? Or is there a different way to accomplish my goal here?

Thanks for you assistence!

Geoff

Best Answer

  • Answer ✓

    Hi Geoff,

    The "=" sign at the beginning, to indicate a function is being entered, is valid for the entire cell. You do not need to repeat it for each function you enter in the cell. If you change "=NETDAYS" to "NETDAYS" it shoud function as you want.

Answers

  • Answer ✓

    Hi Geoff,

    The "=" sign at the beginning, to indicate a function is being entered, is valid for the entire cell. You do not need to repeat it for each function you enter in the cell. If you change "=NETDAYS" to "NETDAYS" it shoud function as you want.

  • That did it, thanks Jacob!

Sign In or Register to comment.