Forum Discussion

Stuznet's avatar
Stuznet
Icon for Helper V rankHelper 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. 

 

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

 

Can someone please help?

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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Stuznet

     

    The formula you have is invalide because you are using AND condition and only condition1 is listed. Here is how I fix it:

     

    Column = IF ( DATEDIFF(
                      [InvDate], [DateReceived], Day) <50
                      ,"<50 Days"
                      ,"50+ Days ")
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Stuznet

     

    Use this.

     

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

     

    Thanks

    Raj