1
Scott posted an answer for this Microsoft Excel for PC:
"One useful technique for this type of thing is to use the MAX function. If you put your..."
ScottScott posted an answer for this Microsoft Excel for PC:
"One appraoch that comes to mind is to nest an AND function into your IF statement along..."
Scott
Scott posted an answer for this Microsoft Computers & Internet:
"Formula is =10-(2+2)"
ScottScott posted an answer for this Microsoft Excel for PC:
"First we need a way of finding how many times each name appears. This job is probably..."
ScottScott posted an answer for this Microsoft Excel for PC:
"There are 2 types of direct cell references that you can use when you're writing formulas:..."
ScottScott posted an answer for this Microsoft Excel for PC:
"Yes, use Conditional Formatting. Select the range that you want the highlights to work on..."
ScottScott posted an answer for this Microsoft Excel for PC:
"The Little Green Triangle (LGT) is an indicator to alert you to a potential error in your..."
ScottScott posted an answer for this Microsoft Excel for PC:
"If you have a number in Cell A2 (say 100), and you put the amount of percentage increase..."
ScottScott posted an answer for this Microsoft Excel for PC:
"Select the data range that you want to sort alphabetically. Ensure that the active cell is..."
ScottScott posted an answer for this Microsoft Excel for PC:
"It might be as simple as Frozen Panes. Go Window / Unfreeze Panes and see whether that..."
ScottScott posted an answer for this Microsoft Excel for PC:
"It's a bit counter-intuitive... Go Insert / Name / Define and the Define Name Dialog box..."
ScottScott posted an answer for this Microsoft Excel for PC:
"If the value in A1 is 100, and the value of A2 is 120, then the formula =(A2/A1)-1 will..."
ScottScott posted an answer for this Microsoft Excel for PC:
"Gross = Net/PercentageThatNetIsOfGross"
ScottScott posted an answer for this Microsoft Excel for PC:
"=1000/8.25% =13,333.3333*"
ScottScott posted an answer for this Microsoft Excel for PC:
"Try using a formula like this in Col AI: =IF(AG9<>1,0,MAX(AI$1:AI8)+1) A couple of..."
ScottScott posted an answer for this Microsoft Excel for PC:
"The WorkDay Function returns a number that's the serial date that is the indicated number..."
ScottScott posted an answer for this Microsoft Excel for PC:
"Hi Anonymous, I want to help you with your problem, but I need more information from you...."
Scott
Scott posted an answer for this Pedals Cycling:
"Go and buy a Pedal Wrench (at your Local Bike Shop, or online). If you buy it from your..."
Scott
Scott posted an answer for this Audio Players & Recorders:
"If you have an iPhone, then go to Settings, iCloud - then you should see your account name..."
Scott
Scott posted an answer for this 1996 Italdesign Formula:
"I assume that the dates you want adjust are in date form and are in regular columns (or..."
ScottScott posted an answer for this Computers & Internet:
"brand, breed, category, character, description, form, group, lot, nature, number, sample,..."
ScottScott posted an answer for this 1996 Italdesign Formula:
"Try this: =EDATE(CellRef,12) where CellRef refers to the cell with the input date. Hope..."
ScottScott posted an answer for this Microsoft Excel for PC:
"Try a formula like this: =COUNTIF(CellRange,"<>TBD") where CellRange is the area..."
Scott
Scott posted an answer for this Microsoft Office 2007 Enterprise Edition Full Version (License Only) Volume License for PC (76J00323):
"Sorry Anthony, I can't help you with that question.Good luck,Scott"
Scott
Scott posted an answer for this Apple MacBook Air:
"flashing question mark"
ScottScott posted an answer for this Apple MacBook Air:
"A flashing question mark indicates that your computer cannot find valid system software...."
ScottScott posted an answer for this Microsoft Excel for PC:
"Insert a calculated field named % Change in Value to determine the percent change in..."
ScottScott posted an answer for this Cycling:
"Here's a good place to go for some help: ..."
ScottScott posted an answer for this Cycling:
"I have a Schwinn World Sport bicycle. I would like to know some more information on..."
ScottScott posted an answer for this Computers & Internet:
"Here's a link to Google Translate that I think will give you what you're looking..."
Scott
Computers & Internet 27 answers
Cycling 7 answers
Cars & Trucks 2 answers
Audio Players & Recorders 1 answer
