Formula for Symbols

ldavenportHAP

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

Paul Newcome

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

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.

ldavenportHAP

@Paul Newcome thank you!

Paul Newcome

Happy to help. 👍️