Question about Microsoft Office Standard for PC

1 Answer

Excel problem i want to remove a 1 = a1

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points


    An expert that gotĀ 5 achievements.


    An expert who has achieved Level 3.


    An expert that hasĀ over 500 points.

  • Master
  • 461 Answers
Re: excel problem

I do not understand your problem pls explain further

Posted on Aug 29, 2007

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

2 Answers

I want the data when typed into cell A1 in sheet 1 to automatically show in cell A22 in sheet 3

If you're using MS Excel it's easy, go to cell A1 and hit "Ctrl" and "C" to copy the cell, then go to cell A22 in sheet three, type in the "=" sign and paste ("Ctrl" and "v" at the same time) the info into the cell. It should look like: =Sheet1!A1

This is a PC answer, not an Apple answer, but in theory it should work for Apple too.

Nov 22, 2015 | Microsoft Excel for PC

3 Answers

Can't see coordinates in Excel Formulas

And this is when you have selected a box and simply type something ?

Dec 28, 2007 | Business & Productivity Software

1 Answer

Insert a calculated field named % Change in Value to determine the percent change in values by type in Excel?

If field A1 is the old value and A2 is the new value, then the formula for A3 (% change) is:=(A2-A1)/A1*100You can remove the *100 if you want to format the field to the Percent type.

Sep 30, 2011 | Microsoft Excel 2010

1 Answer

I want to use a formula to convert (i.e.) 2'-6" to display 26

if A1 has the value as 2'-6".... your formule should be as below to obtain the desired reuslt...


Sep 22, 2011 | Microsoft Excel for PC

2 Answers

I want to write an Excel IF statement using only mathematical operators (in another application). The Excel formulation is: ...

Let say you have table like this
' A ' B
1 ' First ' 2
2 ' Second ' 1
3 ' Third ' 3
On Cell C1 or other cell you like, try to type this formula

That's all, just IF and math operand


Apr 05, 2011 | Microsoft Excel for PC

3 Answers

Pls help to write an excel formula to display date, thanks! Cell A1 input a date - 1 Sep 10, Cell B1 write a formula to calculate & display the date which = (A1 + 14 days but if the result is a...

This is too complicated for a help site like this, you are going to want to consult an excel forum, or some excel professional in your area. This is far beyond the scope of what you can expect for $15, which I'm sure you now realize after 10 days of trying.


Sep 26, 2010 | Microsoft Excel for PC

2 Answers

Text within an IF formula

Use this formula in B1: =CHOOSE(A1,"GOOD","FAIR","BAD")
With this you must have 1, 2, or 3 in A1 or you will get a #VALUE error in B1.

May 20, 2009 | Microsoft EXCEL 2004 for Mac

4 Answers

Using excel to solve problem by trial and error method

In A1, put a random value of d as 0.1. Then in B1, put your equation 5*d^4 - 10.29*d^(-1.333), wherein refer d as A1. Then use goal seek function on Tools Menu. First "Set cell" as B1, "To value" as 0.124 and "By Changing Cell" as A1. Excel will do the Trial & Error and will give you the answer in Cell A1.


Mar 31, 2009 | Microsoft EXCEL 2004 for Mac

1 Answer


Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.

Add 1 + 1: =1+1
Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1
Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2
Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Aug 08, 2008 | Microsoft Business & Productivity Software

1 Answer

Ms excel function

I'm not entirely sure how you want to use this, but it is fairly easy to automatically assign a value to a cell based on the value in another.

Let's assume that you enter your score (A, B, C or D) in cell A1. If you put the following equation in cell A2 it will then display the corresponding score:


You can go on adding as many further 'IF' statements as you like.

You can elaborate on this a bit by changing it to the following:

=IF(A1="A",3,IF(A1="B",2,IF(A1="C",1,IF(A1="D",0,"Not Scored"))))

By adding the final 'Not Scored' entry it prevents cell A2 from displaying 'FALSE' as an output.


Feb 26, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

15 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides