Formulas

NetguyIT

I am trying to write an IF statements that allows me to set either an up, sideways or down arrow based on the the difference between two dates. I have found many example and have tried to reverse engineer them however I am not having any luck

Basically if the two date fields when subtracted = a number less then or = 7 then display Up arrow 

OR if the two date fields when subtracted = a number between 8 and 12 then display Sideways arrow 

OR if the two date fields is greater than 13 then display Down Arrow

 

Here is what I have but its indicating Unparseable. Not sure if I have ( ) in the right place. Any help would be great, 

 

=IF([End Date]1 - [Base Line END Date]1 >= 1, [End Date]1 - [Base Line END Date]1 <= 7, “Up”, IF([End Date]1 - [Base Line END Date]1 >= 8, [End Date]1 - [Base Line END Date]1 <= 12, “Sideways”,“Down”))

NetguyIT

Actually I believe this Works for me:

 

=IF([End Date]1 - [Base Line End Date]3 <= 7, “Up”, IF([End Date]1 - [Base Line End Date]1 > 30, “Down”, “Sideways”))