cells not calculating?? Help

sbowen666

New Member
Joined
Sep 15, 2006
Messages
10
Please help.

I have a spreadsheet that just has a simple total formula in the bottom line.
However for some reason the formula doesnt put a value in the cell instead it appears to be blank.
You can see the formula in the formula bar but nothing appears in the cell.
(i have checked tools -options-calculation) and also that the text colour is not the same as the background colour).
If i try copying the formula left, even though the cells referenced in the formula change the total will come out as the first column.

I hope i have explianed things properly.
I would be grateful of any suggestions on this matter please.

Regads
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
50,644
Office Version
  1. 365
Platform
  1. Windows
sbowen666

Another check would be to select the cell then
Format|Conditional Formatting... to see if any Conditional Formatting might be causing the problem.
 

Dan71

New Member
Joined
Jul 31, 2006
Messages
48
It could be that the Auto calculate is switched off. Try pressing F9 when you have copied the formula. If this works you can swich the auto calculate back on in;
Tools
Options
Calculations (a tab at the top)
 

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good afternoon sbowen666

From the offending cell, press Ctrl + 1 to open the Format Cells box, go to the number tab and see what the format is set to. For example ;;; set as a custom formula will hide the result in the cell - other custom formats can interfere in the way formula results are displayed.

HTH

DominicB
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
What is your formula, and miht it be evaluating to either 0 or "" at the moment?
 

sbowen666

New Member
Joined
Sep 15, 2006
Messages
10
Dominic B,
Thank you very much. somehow the format had been altered causing the problem.

Thank you everyone who contributed as well.


Regards
 

Forum statistics

Threads
1,141,588
Messages
5,707,264
Members
421,498
Latest member
matinebi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top