bobjglover@gmail.com
New member
- Joined
- Aug 3, 2015
- Messages
- 57
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 1901
Hello Guru's,
Hope you can assist, this is returning Red parens on the nested part and not working. g3 is the same as @Days left column - I am guessing this is a new function of xlsx. describing a cell when you = it?
=IF(g3<0, "Expired",if([@[Days Left]]<30, "Expiring Soon", ""))
Thanks - Bob
Hope you can assist, this is returning Red parens on the nested part and not working. g3 is the same as @Days left column - I am guessing this is a new function of xlsx. describing a cell when you = it?
=IF(g3<0, "Expired",if([@[Days Left]]<30, "Expiring Soon", ""))
Thanks - Bob