Forum Discussion

Stuznet's avatar
Stuznet
Helper V
7 years ago
Solved

If Statement Then Output Custom Text

Hi guys,   I'm having little trouble writing an IF statement.    Here is the logic DateReceived minus Inv Date being greater or less than 50.  This is the the function I wrote but is invalid.  ...
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Stuznet

     

    Use this.

     

    Column = IF ( Table1[DateReceived] - Table1[InvDate] < 51 , "<50 Days","50+ Days ")

     

    Thanks

    Raj

Stuznet's avatar
Stuznet
Helper V
7 years ago

Anonymousperfect as always. :) 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you Stuznet :)