IF statement returns formula statement, not value of formula

Jessica Abbey

I want the value if true, value if false in my IF statement to return the results of 2 different formulas. But if returning the language of the formula itself on the value of the formula. I need this cell to show how long a position has been open, and if there is a position fill date, how long it was open before being filled. What am I doing wrong?

=IF([Position Filled Date]@row = "", "=NETDAYS([Date Position Vacated]@row, (TODAY()))", "=NETDAYS([Date Position Vacated]@row, [Position Filled Date]@row)")

Mike Wilday

Well, one reason it is returning your formula is because you have wrapped the formula in quotes. When running another formula inside of an IF statement you don't want to reuse the equal sign.

=IF([Position Filled Date]@row = "", NETDAYS([Date Position Vacated]@row, TODAY()), NETDAYS([Date Position Vacated]@row, [Position Filled Date]@row))

Does that work for you?

Jessica Abbey

That did it! Thank you! I can just add an IF/AND to my statement to get rid of the #INVALID DATA TYPE when both the cells in question are blank right?

Mike Wilday

Would you ever have a Postiion filled cell populated with a Date position blank? If not, try this...

=IF(ISBLANK([Date Position Vacated]@row), "", IF([Position Filled Date]@row = "", NETDAYS([Date Position Vacated]@row, TODAY()), NETDAYS([Date Position Vacated]@row, [Position Filled Date]@row)))

This formula checks to see if the position vacated row is blank and returns a blank if it is. Then it goes through the rest of the prior formula.