Excel problem i want to remove a 1 = a1

1 Answer

Anonymous

Level 3:

An expert who has achieved level 3 by getting 1000 points

MVP:

An expert that got 5 achievements.

Master:

An expert who has achieved Level 3.

Sergeant:

An expert that has over 500 points.
Master
461 Answers

I do not understand your problem pls explain further

Posted on Aug 29, 2007

Add Your Answer

Upload

Upload an image from your computer

Uploading: 0%

my-video-file.mp4

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

Loading...

Include an image. It's worth a thousand words.

prev next

Related Questions:

0helpful

2answers

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.

Read full answer

Nov 22, 2015 • Microsoft Excel for PC

0helpful

1answer

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.

Read full answer

Sep 30, 2011 • Microsoft Excel 2010

0helpful

1answer

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...

=(LEFT(A1,FIND("'",A1,1)-1))&(MID(A1,FIND("-",A1,1)+1,(FIND("""",A1,1)-(FIND("-",A1,1)+1))))

Read full answer

Sep 22, 2011 • Microsoft Excel for PC

2helpful

2answers

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
=IF(B1<B2;IF(B2<B3;A1;IF(B1<B3;A1;A3));IF(B2<B3;A2;A3))

That's all, just IF and math operand

Read full answer

Apr 05, 2011 • Microsoft Excel for PC

44helpful

3answers

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.

Thanks
Tim

Read full answer

Sep 26, 2010 • Microsoft Excel for PC

2helpful

2answers

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.

Read full answer

May 20, 2009 • Microsoft EXCEL 2004 for Mac

7helpful

4answers

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.

Nilesh

Read full answer

Mar 31, 2009 • Microsoft EXCEL 2004 for Mac

0helpful

1answer

Computer

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.

Read full answer

Aug 08, 2008 • Microsoft Computers & Internet

0helpful

2answers

Regarding Excel formulas

Yes, its possible by designing a formula in excel.

Read full answer

Aug 03, 2008 • Microsoft Windows XP Professional

0helpful

1answer

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:

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

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.

Matt

Read full answer

Feb 26, 2008 • Microsoft Excel for PC