Silverjman
Board Regular
- Joined
- Mar 19, 2014
- Messages
- 110
Omigosh I'm about to lose my mind.
Why is Excel taking me to the fifth cell in my formula instead of the first?! All that mattes here is that I want to go to CA325 if I double click or ctrl +{ (YES, "Allow directly editing in cells" is OFF)
I thought maybe it had something do with the fact that the cell I didn’t want was the left most column so I moved it to 100 columns to the right and right of the cell I wanted. Then I thought maybe it was because that was the $ (locked) column so unlocked the column.
THANK FOR READING!
Why is Excel taking me to the fifth cell in my formula instead of the first?! All that mattes here is that I want to go to CA325 if I double click or ctrl +{ (YES, "Allow directly editing in cells" is OFF)
Code:
=(CA325*0)+
IF(JA$2<=ActualsEndDate,IF(OR(CA325>4,CA325<1),CA325,0),CHOOSE(IF(CA325="",$HA325,CA325),(CA325=JA$3)*SUM(INDEX(BuildingsCF!$U125:$CB125,(JA$1)):INDEX(BuildingsCF!$U125:$CB125,JA$1)),(CA325=JA$3)*SUM(INDEX(BuildingsCF!$U125:$CB125,(JA$1)):INDEX(BuildingsCF!$U125:$CB125,JA$1)),(CA325=JA$3)*SUM(INDEX(BuildingsCF!$U125:$CB125,(JA$1)):INDEX(BuildingsCF!$U125:$CB125,JA$1)),SUM(INDEX(BuildingsCF!$U125:$CB125,(JA$1)):INDEX(BuildingsCF!$U125:$CB125,JA$1))/3))
I thought maybe it had something do with the fact that the cell I didn’t want was the left most column so I moved it to 100 columns to the right and right of the cell I wanted. Then I thought maybe it was because that was the $ (locked) column so unlocked the column.
THANK FOR READING!