Skip to Content
0

Analysis for Office overwriting Excel formula

May 05, 2017 at 04:07 PM

146

avatar image

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

10 |10000 characters needed characters left characters exceeded

Hi Kelly - which version of Excel are you using?

0

Excel 2016

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Torsten Wirth May 31, 2017 at 10:03 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Tammy Powlas
May 31, 2017 at 05:58 PM
0

Kelly - interesting, I tried this with 2.5 and cannot replicate the issue. Hopefully 2.5 will be out soon.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Tammy - Yes. I have that question (general availability of 2.5) in another post.

0
avatar image
Former Member Oct 19, 2017 at 04:45 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded