Formula for Symbols
Hello!
hope this is easy enough but im still trying to master my formulas with symbols. Can anyone help me with this one? I need to use the symbol to indicate if current month is more, less or same as prior month @row
Best Answer

You would use a nested IF statement.
=IF([AR Days Current Month]@row>[AR Days Prior Month]@row, "up arrow", IF([AR Days Current Month]@row<[AR Days Prior Month]@row, "down arrow", "right arrow"))
You will need to replace each "directional arrow" with the appropriate text value. You can find out what text values to use by clicking on one of the cells in the symbol column and expanding the options as if you are going to manually select them.
Answers

You would use a nested IF statement.
=IF([AR Days Current Month]@row>[AR Days Prior Month]@row, "up arrow", IF([AR Days Current Month]@row<[AR Days Prior Month]@row, "down arrow", "right arrow"))
You will need to replace each "directional arrow" with the appropriate text value. You can find out what text values to use by clicking on one of the cells in the symbol column and expanding the options as if you are going to manually select them.

@Paul Newcome thank you!

Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!