Hi - I am using AO 2.4.1.2 and adding a column for an Excel formula. When I add the formula below, AO changes it when used (I hit enter).
Formula typed:
=IF(SUM($I$28:I28)<=80,"A",IF(SUM($I$28:I28)<=95,"B","C"))
Formula AO changes to:
=IF(SUM($I$28:$I$28)<=80,"A",IF(SUM($I$28:$I$28)<=95,"B","C"))
Any ideas on how to I can get this to stay as typed?
Kind regards,
Kelly
Hi Kelly - which version of Excel are you using?
Excel 2016
I think this is normal behaviour if you add the formuals in the are of AO crosstabs. That's the behaviour I have seen as I used this function last time.
Kelly - interesting, I tried this with 2.5 and cannot replicate the issue. Hopefully 2.5 will be out soon.
Hi Tammy - Yes. I have that question (general availability of 2.5) in another post.
Hello
I try this on Analysis 2.5 :
- Column before
- in this column i add the formula : = B2&C2
Formula AO changes to: =$B$2&$C$2 on all rows, i can't change them.
Any ideas ?
Kind regards,
Thierry