Question about Microsoft Excel for PC

1 Answer

I need to write a formula in a cell but need the little green triangle in the left hand corner of the cell for it to except the formula

Posted by Anonymous on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    New Friend:

    An expert that has 1 follower.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Contributor
  • 38 Answers

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

Ad

4 Suggested Answers

6ya6ya

6ya staff

  • 2 Answers

SOURCE:

Hi there,
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

Good luck!

Posted on Jan 02, 2017

Ad
danilomanjr

Danilo Mante

  • 45 Answers

SOURCE: How do I say look at cell on left rather than the cell number

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

Squirm57

Dave Herard

  • 152 Answers

SOURCE: When I enter a formula the cell displays the

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

ronanreynera

Ronan Reynera

  • 166 Answers

SOURCE: Problem was found in Micorsoft

Once you have copy the cell from where the formula cam from, on the destination cell,
go to
1. Edit
2. Paste Special
3. Formula.
4. Press Enter

This should resolve your problem. Regards.

Posted on Aug 18, 2010

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Changing my facebook password


While logged into Facebook through a web browser:
  1. Click the little triangle pointed down in the upper right-hand corner of your Facebook page.
  2. Choose Settings
  3. Below General on the left, click on Security and Login
  4. Click the Edit button to the right of Change Password
  5. Enter your Current password then enter your New password and Re-type your new password.

Oct 24, 2017 | Facebook Computers & Internet

1 Answer

How do I copy a formula down a column in a spreadsheet


I'm not sure.......try right clicking and holding down the right hand corner of the cell that has the formula, then drag it down into all the other cells in that column.

let me know
Joe

Mar 04, 2017 | Formula Computers & Internet

1 Answer

Superpad i7 model p745! locks up


This is posted in wrong catagory--please repost in the area related to this unit.

Apr 08, 2012 | Televison & Video

1 Answer

What is the red warning triangle in top left hand corner after trying to get numbers from old sim card?


Hi I had this too.

You need to put your finger the triangles, you'll see a grey tab appear under your fingure. Drag this tab down to show on full screen. Now you will be in notification section. You can now deal with your problem. it is telling you download unsucessful or not enough storange on the phone. Dont ask for it to install.

I hope that help.

Oct 09, 2010 | Samsung Galaxy S GTI9000 Smartphone

2 Answers

Error on page in bottom left had corner


I have a yellow triangle on the bottom left hand corner of my facebook.
I cannot open my home page, chat or write any comments.
When I double click on the triangle it states that I have errors.

Can you help me solve this problem please.

Thanks

Sep 13, 2009 | Facebook Social Network

1 Answer

Red triangle on left hand top corner - K800i


hi
triangle means roaming if its a red triangle then your internet is turned off while roaming


go to options>mobile network> data services and select what setting you would like either on all the time, off, or off while roaming

solid triangle means extended network (coverage with another carrier that your service provider has an agreement with). some services might not work

blinking triangle is roaming (on a network with no agreement)...most carriers have simply disabled roaming entirely, you either get their network, or extended network to avoid additional charges. int'l roaming is different, not restricted. if you're near either of the borders, i'd say choose "home only" under network options to avoid int'l charges

Hope that helps

May 25, 2009 | Sony Ericsson K800i Cellular Phone

1 Answer

Cheat codes


R1, R2, L1 , X, Left , Down, Right, Up, Left, Down, Right, Up $250,000, full health and armor (also repairs cars if you are in one) RIGHT, R2, UP, UP, R2, CIRCLE, SQUARE, R2, L1, RIGHT, DOWN, L1 Aggressive Drivers R2, Circle, R1, L2, Left R1, L1, R2, L2 Aggressive Traffic LEFT, TRIANGLE, R1, L1, UP, SQUARE, TRIANGLE, DOWN, CIRCLE, L2, L1, L1 All Cars Nos L1, Circle, Triangle, L1, L1, Square, L2, Up, Down, Left All Pedestrians Are Elvis L2, RIGHT, L1, UP, X, L1, L2, R2, R1, L1, L1, L1 All Traffic is Junk Cars Right, R1, Up, L2, L2, Left, R1, L1, R1, R1 All Traffic Lights Stay Green Triangle, L1, Triangle, R2, Square, L1, L1 All Vehicles Invisible (Except Motorcycles) x, x, square, r1, l1, x, down, left, x Andrenaline mode

Mar 29, 2009 | Rockstar Games Grand Theft Auto III & Vice...

1 Answer

Can we use cut copy paste in excel


You do not need to cut copy or paste to get this to work. If you click on the cell that the formula is currently in, you will see that the border of the cell changes and in the lower right corner of the cell there is a small square. If you move your mouse pointer over that little square your pointer should change to a small plus sign. Click and drag to the right and the formula will automatically change to the next set of cells.

Mar 27, 2009 | Computers & Internet

5 Answers

Formula required


at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

Dec 04, 2007 | Microsoft Excel for PC

3 Answers

How can I remove the little 'green key' in the lower left hand corner of the screen


Try pressing the "F" or function button and hold while pressing the Mute or "M" button at the same time. Good Luck

Jul 27, 2006 | Apex Digital AT1314DV 13 in. TV/DVD Combo

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

71 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

ThaMp3Doctor
ThaMp3Doctor

Level 3 Expert

8597 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...