the formula in this cell differs from formulas in this area of th

  • Thread starter Thread starter Guest
  • Start date Start date
It's probably not an error, just a remark.
Please give your formulas and the formluas for surrounding cells if you
still think something's wrong

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
If you have a bunch of formulas in B1:B10 that look like this:

=A1*2+33
=A2*2+33
=A3*2+33
=A4*2+33
=A5*2+33
=A6*2+33
=A7*2+33
=A8*2+33
=A9*2+33
=A10*2+33
=A11*2+33
And then have a formula like this in B12:
=A12*2+22
and then this in B13:b15
=A13*2+33
=A14*2+33
=A15*2+33


Excel tries to help you by saying that your formulas are not the same in that
area.

If you really meant to change the formula, then ignore the message. But it
could mean that someone changed the formula and screwed it up.

Although, the message I see is "inconstent formula".
 
Back
Top