View original (French)

[EXCEL] "inconsistent formula" error?

mortelrdv -  
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   -
Hello,

I have a column A with values
I have another column B with:
row 1 column B: =ROUNDUP(A1*(1+0.35),0)
row 2 column B: =ROUNDUP(A2*(1+0.35),0)
row 3 column B: =A3
row 4 column B: =A4
row 5 column B: =ROUNDUP(A5*(1+0.35),0)
etc...

sometimes I have a little green triangle in the top right of a cell in column B
it tells me "inconsistent formula"...

is it serious? why do I have this problem when I sometimes simply have =A15 in the cell?

Thank you
Configuration: Windows XP Internet Explorer 6.0

7 réponses

Réponse 1 / 7
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
Hello
I don't think it's a big deal. In fact, Excel detects that you have different formulas in the same column.
If you find that it doesn’t affect the results, you just need to remove the control option applied by Excel:
Taskbar / Tools / Options / Error Checking / Uncheck the box corresponding to "inconsistent formula" in the dialog box and you should no longer see this display.
Best regards.
--
Science without conscience is but the ruin of the Soul
4