Formula Help w/arrows
Hello,
I need help with the following formula:
=IF([Risk Level Total (IMPACTxPROBABILITY)]@row = 25, "Down", IF([Risk Level Total (IMPACTxPROBABILITY)]@row <= 20, "Angle Down", IF([Risk Level Total (IMPACTxPROBABILITY)]@row <= 12, "Sideways", IF([Risk Level Total (IMPACTxPROBABILITY)]@row <= 10, "Angle Up", "Up"))))
I need "Down" if score is 25, "Angle Down" if score is between 15 and 20, "Sideways" if score is between 1012, "Angle Up" is score is between 59, and Up if score is between 14. Thank you!
Answers

Try this. Keeping in mind that there are some scores that won't equate to a symbol. Example, 21 through 24 will not.
=IF([Risk Level Total (IMPACTxPROBABILITY)]@row = 25, "Down", IF(AND([Risk Level Total (IMPACTxPROBABILITY)]@row >= 15, [Risk Level Total (IMPACTxPROBABILITY)]@row <= 20), "Angle Down", IF(AND([Risk Level Total (IMPACTxPROBABILITY)]@row >= 10, [Risk Level Total (IMPACTxPROBABILITY)]@row <= 12), "Sideways", IF(AND([Risk Level Total (IMPACTxPROBABILITY)]@row >= 5, [Risk Level Total (IMPACTxPROBABILITY)]@row <= 9), "Angle Up", IF(AND([Risk Level Total (IMPACTxPROBABILITY)]@row >= 1, [Risk Level Total (IMPACTxPROBABILITY)]@row <= 4), "Up", "")))))

This is it. Thank you so much!

There's many ways to do your nested IF but let's ride with this one, and I'd like to point out a few points first:
 What happens if score is between 21 and 24?
 What happens if score is either 13 or 14?
 What happens if score is 0?
Those two cases are not part of what you want to do?
Maybe your score cannot reach these numbers, in which case it's fine, but if they do, the formula will return the default answer. ("Up" in your case).
Keeping this in mind, here we go so that we cover every possibilities as you want them:
=IF([Risk Level Total (IMPACTxPROBABILITY)]@row>5, IF([Risk Level Total (IMPACTxPROBABILITY)]@row>10,IF([Risk Level Total (IMPACTxPROBABILITY)]@row>15, IF([Risk Level Total (IMPACTxPROBABILITY)]@row>20, IF([Risk Level Total (IMPACTxPROBABILITY)]@row=25, "Down", ""),"Angle Down"),IF([Risk Level Total (IMPACTxPROBABILITY)]@row>12, "", "Sideways),"Angle Up"), IF([Risk Level Total (IMPACTxPROBABILITY)]@row=0, "", "Up")
Other way to do it using AND:
=IF([Risk Level Total (IMPACTxPROBABILITY)]@row=25, "Down", IF(AND([Risk Level Total (IMPACTxPROBABILITY)]@row>=15, [Risk Level Total (IMPACTxPROBABILITY)]@row=<20, "Angle Down", IF(AND([Risk Level Total (IMPACTxPROBABILITY)]@row>=10, [Risk Level Total (IMPACTxPROBABILITY)]@row=<12), "Sideways", IF(AND([Risk Level Total (IMPACTxPROBABILITY)]@row>=5, [Risk Level Total (IMPACTxPROBABILITY)]@row=<9), "Angle Up", IF([Risk Level Total (IMPACTxPROBABILITY)]@row>=1,[Risk Level Total (IMPACTxPROBABILITY)]@row=<4, "Up", "")))))
Up to you!
Hope it helped!
Categories
 All Categories
 14 Welcome to the Community
 10.9K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.6K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives