Question about Microsoft Excel for PC
Posted by Anonymous on
The Little Green Triangle (LGT) is an indicator to alert you to a potential error in your formula. The LGT doesn't stop you from entering a formula (with or without an error), it's just an alert to check that it's OK. If you're happy with the formula you've entered, then you can just ignore the LGT and carry on.
If it's bugging you, you can turn off background error checking.
Go Tools / Error Checking / Options / and uncheck "Enable background error checking". That will turn off the LGTs.
Posted on Sep 09, 2014
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
vlookup can only locate values within the lookup range and to the right of the lookup column. to address your concern, i'd advise you to create a dummy column within the lookup range (and hide it) and link it to the lookup column. this way, we won't need a (-) column index number.
Posted on Nov 17, 2008
You can change this under the Excel, options menu. Select the advanced option and uncheck the option to "Show Formulas in cells instead of their calculated value", or you can jjst press Ctrl + `
This will either turn on or off the show formula option.
Posted on Apr 27, 2009
SOURCE: Problem was found in Micorsoft
Once you have copy the cell from where the formula cam from, on the destination cell,
2. Paste Special
4. Press Enter
This should resolve your problem. Regards.
Posted on Aug 18, 2010
Tips for a great answer:
Oct 24, 2017 | Facebook Computers & Internet
Mar 04, 2017 | Formula Computers & Internet
Oct 09, 2010 | Samsung Galaxy S GTI9000 Smartphone
Sep 13, 2009 | Facebook Social Network
May 25, 2009 | Sony Ericsson K800i Cellular Phone
Mar 29, 2009 | Rockstar Games Grand Theft Auto III & Vice...
Mar 27, 2009 | Computers & Internet
Dec 04, 2007 | Microsoft Excel for PC
Jul 27, 2006 | Apex Digital AT1314DV 13 in. TV/DVD Combo
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
71 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: