Calculation within IF statement

GTigs

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

Jacob Ernst

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.

Jacob Ernst

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.

GTigs

That did it, thanks Jacob!