What could be the reason

[mahen]

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]

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

 

[SteveH2508]

Is calculation set to manual or automatic?

 

[mahen]

automatic. see attached file. Column H and I are automatic.

 

[godsspeed]

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]

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: