ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   the formula in this cell differs from formulas in this area of th (https://www.excelbanter.com/new-users-excel/36463-formula-cell-differs-formulas-area-th.html)

turkey

the formula in this cell differs from formulas in this area of th
 
i have this error in a cell and the help section will not show up. can
anyone help?
--


Niek Otten

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

"turkey" wrote in message
...
i have this error in a cell and the help section will not show up. can
anyone help?
--




Dave Peterson

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".


turkey wrote:

i have this error in a cell and the help section will not show up. can
anyone help?
--


--

Dave Peterson


All times are GMT +1. The time now is 08:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com