Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formulas not calculating
I posted this as an addition to a prev question and was hoping to get some
feedback with a more appropriate subject line... My workbook is beginning to get screwy. I will go to enter a formula like the one below and it won't calculate it! I've checked the following items auto calculate is on I have no other workbooks open to toggle it to manual ctrl+~ doesn't do anything ctrl+F9 minimizes the workbook F9 doesn't do anything under tools/options/calcs/ calc sheet and calc now don't work (Ctrl N opened a new blank workbook). This is a pretty complicated workbook with 8-10 pages of multiple linked offset and vlookup formulas.... Am I overloading things? My original post was: I'm trying to find a formula that will give me the row header in column a if there is an x in the column B1:B4. A B C D E F W1 x x x W2 x x x W3 x x x x W4 x I've tried =IF(B1:B4,"x",A1:A4) Probably not quite right...I'm trying to find a formula that will give me the row header in column a if there is an x in the column B1:B4. A B C D E F W1 x x x W2 x x x W3 x x x x W4 x I've tried =IF(B1:B4,"x",A1:A4) Probably not quite right... Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
not calculating formulas | Excel Discussion (Misc queries) | |||
Formulas not calculating??? | Excel Discussion (Misc queries) | |||
Turning off auto unhide when calculating formulas | Excel Worksheet Functions | |||
Formulas stop calculating at random times when editing a few spreadsheets. | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |