Question about Microsoft Office Standard for PC

Excel problem i want to remove a 1 = a1

1 Answer

SS s

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:

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

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

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

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

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.

Thanks
Tim

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.

Nilesh

Mar 31, 2009 | Microsoft EXCEL 2004 for Mac

1 Answer

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.

Aug 08, 2008 | Microsoft Computers & Internet

2 Answers

Regarding Excel formulas

Yes, its possible by designing a formula in excel.

Aug 03, 2008 | Microsoft Windows XP Professional

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:

=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

Feb 26, 2008 | Microsoft Excel for PC

Not finding what you are looking for?

View Most Popular

Office Standard for PC

Computers & Internet

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

Microsoft Excel for PC

Open Questions:

0 Answers

Ask a Question

Usually answered in minutes!

Check Out the Mobile Browsers Report

View all Fixya Reports

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

Answer questions

Manuals & User Guides

Have a manual for Microsoft Office Standard for PCs? Or just drag it here!

Excel problem i want to remove a 1 = a1

1 Answer

SS s

Add Your Answer

Attachments: Added items

Related Questions:

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

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

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

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