# What could be the reason (1 Viewer)

#### mahen

##### Registered User.
An excel workbook created in 2003 and modified in 2010. For some reason cannot get the result of the calculation. Formula was there before and still there. For some reason result is blank. What could be the reason? same problem for all work sheet in the work book.

#### mahen

##### Registered User.
When save the file after entering the figures, the formulas working. Why?

#### SteveH2508

##### Registered User.
Is calculation set to manual or automatic?

#### mahen

##### Registered User.
automatic. see attached file. Column H and I are automatic.

#### Attachments

• Errorfile.xls
24.9 KB · Views: 72

#### godsspeed

##### Registered User.
H14 will be Blank because that is what your formula is set to do.
IF(G14<(D14-C14):
If G14(3:30) is less than D14-C14 (which is also 3:30)...
this condition would be false as it is equal to...therefore, it goes to the Value if False Argument which is ""...meaning blank.

as for Col I: that will result in a "blank cell" unless C14 and D14 both contain data. the formula is basically saying if either C14 or D14 are blank, the result will be blank.

#### mahen

##### Registered User.
Hi Goodspeed,
Put some value in C18 AND D18, the result should come on H18 & I18? Why no result?

#### boblarson

Hi Goodspeed,
Put some value in C18 AND D18, the result should come on H18 & I18? Why no result?

Because your Calculations as mentioned by SteveH2508 are set to MANUAL. How did you check to see if they are set to Automatic? I just opened the sheet and it is set to manual:

#### Attachments

• 4-15-2013 9-27-47 AM.jpg
107.5 KB · Views: 102

Replies
12
Views
95
Replies
6
Views
173
Replies
5
Views
40
Replies
9
Views
187
Replies
7
Views
203