|
|
#2
12-19-2017, 02:55 PM
|
||||
|
||||
When editing the cell, you can use F4 to toggle through all combinations (AB4, $AB4, AB$4, $AB$4). I don't know if using this tip will solve the problem. Your formula appears correct. I've never seen this type of error. You might try writing the formula in the cell by entering the equal sign with the keyboard, selecting AB4 with the mouse, and using F4 (in this case, 3 times) to set the absolute/relative state you want.
Are you referencing a cell on a separate tab (Master Index)? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Absolute Value Size Consistency
|
bdavidson40 | Word | 4 | 08-28-2017 03:48 AM |
| Error message in pivot when i try drag and placing a column in the row label | olybobo | Excel | 0 | 05-10-2016 02:05 PM |
| Always on top, absolute times for slideshow | cab07 | PowerPoint | 0 | 07-06-2014 05:06 AM |
|
Inconsistent Calculated Column Formula Error
|
amlevesq | Excel | 1 | 04-22-2014 11:53 AM |
| column width error message | norwood | Word VBA | 2 | 10-07-2013 05:05 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode