Forum Discussion
RobbieD2020
Jan 17, 2020Copper Contributor
Listing IF formulas
I'm hoping someone out there can help..? I'm trying to list a number of IF formulas in one cell. If I do just the first one by itself, the formula works and I get the correct answer. However, when I...
RobbieD2020
Jan 17, 2020Copper Contributor
Thank you SergeiBaklan
$C22 wont ever = 17 as these are from a cell where the figure is chosen from one of 3 and put in manually. I'll be adding a drop down list to this cell.
I'll certainly try your suggestion in the morning.
SergeiBaklan
Jan 17, 2020Diamond Contributor
If no other options perhaps something like suggested formula could work.