What could be the reason (1 Viewer)

mahen

Registered User.
Local time
Today, 17:50
Joined
Jan 13, 2008
Messages
56
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.
Local time
Today, 17:50
Joined
Jan 13, 2008
Messages
56
When save the file after entering the figures, the formulas working. Why?
 

SteveH2508

Registered User.
Local time
Today, 17:50
Joined
Feb 22, 2011
Messages
75
Is calculation set to manual or automatic?
 

mahen

Registered User.
Local time
Today, 17:50
Joined
Jan 13, 2008
Messages
56
automatic. see attached file. Column H and I are automatic.
 

Attachments

  • Errorfile.xls
    24.9 KB · Views: 72

godsspeed

Registered User.
Local time
Today, 09:50
Joined
Aug 20, 2012
Messages
44
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.
Local time
Today, 17:50
Joined
Jan 13, 2008
Messages
56
Hi Goodspeed,
Put some value in C18 AND D18, the result should come on H18 & I18? Why no result?
 

boblarson

Smeghead
Local time
Today, 09:50
Joined
Jan 12, 2001
Messages
32,068
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
    4-15-2013 9-27-47 AM.jpg
    107.5 KB · Views: 102

Users who are viewing this thread

Top Bottom