You are here:

Business Software

Recent Answers

2016-09-27 Excel - Switching to the sheet your cell getting value from:

The first picture you show looks exactly like my Advanced Options Screen including the 4th checkbox being labelled   "Allow Editing Directly in Cells"    I have captured your image and circled that entry

2016-09-27 Excel - Excel:

I'd probably do this with a lookup table due to the number of possibles, but the rules aren't quite clear as you've shown what appears to be 4 hours 25 minutes and 40 seconds as being less than 2 hours

2016-09-27 Excel - Switching to the sheet your cell getting value from:

Please re-read my answer.  I said to uncheck     Allow Editing Directly in Cells      nothing about move selection.   In you version of excel, those exact words may not be there and I have no idea how

2016-09-26 Excel - Switching to the sheet your cell getting value from:

Haseeb Aslam,    You would have to make a trade-off if you want this functionality.  If you go into Files=>Options, then select Advanced, in the first group of attributes, uncheck     Allow Editing Directly

2016-09-22 Excel - Formula for Goal Seek:

Nabam,      the formula in A1 should be:   =IF(B3="",19000,(B3/A2))    If you read my original post, I was thinking of an approach that would require intentional circular references, but with the formula

Categories

Browse Alphabetically

©2016 About.com. All rights reserved.