Long IF formulas
-
I’m not sure whether this goes under the category of support questions, but they say there are no stupid questions so here it goes.
I’m working on a player stats card for a sportsteam and under the last five games played (Viisi viimeistä ottelua) there is a column where it’s shown in which outfield position the player has played during the game (Example page shows the letter J). For now, I have the free version to work with (sorry about that), but at some point I have to convince management to get a a Pro or Max version.
I have one main table which is the database and where all the individiual stats card pick up the stats to different players. Since Tablepress understands only numbers I figured out a way around this.
Does Tablepress understand really long IF formulas? Formulas that have like 10 different variables (is that the right word for this). For example IF
[table-cell id=1 cell=>A1 /]
is 1 show AA, but if it’s 2 show BB, and so on all the way to ten, but if A1/B1/C1 (and so on) is empty/zero show nothing (“”).I consider myself an experienced Excel user, but I have never tried an IF formula this long, so that’s why I’m asking, if Tablepress can handle it before I start my trial and error journey.
The page I need help with: [log in to see the link]
- You must be logged in to reply to this topic.