#1
|
|||
|
|||
Formula result not displaying in cell (but f9 works)
Hi There,
I've having trouble with what appears to be some kind of glitch. The formulas in the linked spreadsheet (it's too big to attach, sorry) are not displaying the results of the formula, although the formula is definitely correct because the F9 evaluation yields the correct result. Can someone please take a look and see why this might be happening? I've googled across the web but no answers I've seen appear to solve the problem. As a clue, I've noticed that if I delete all the blue sheets (Kay Rd Subdivision (250) - Blackwood RoW (258), the problem is solved. Of course, though, I don't want to delete these sheets... I'm also having a problem with circular references. Whenever I use the today() function, excel is deeming it a circular reference. Does anyone know why this might be? https://drive.google.com/file/d/0B3g...ew?usp=sharing Thanks for your help. Nathan |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
formula, 2 criteria, one result | cjdstephenson | Excel | 4 | 06-02-2015 09:17 PM |
Perform calc in active cell then highlight based on formula result | grexcelman | Excel Programming | 4 | 01-12-2015 11:00 AM |
Show result of formula as a value in another cell | Steve_D | Excel | 4 | 10-12-2014 07:38 PM |
IF formula returns wrong result | mashley | Excel | 3 | 09-07-2012 07:03 AM |
Can I create a formula that will show result in the same cell and let me copy it down | CranstC | Excel | 1 | 02-11-2012 01:29 AM |