Question about Microsoft Office 2003 Basic Edition English (s55-00066) for PC

Sample data:

A1: How to use

A2: Microsoft Excel.

I want A3 to be a formula combining A1 & A2 but with A2 in BOLD letters.

example:

A3: =A1 & bold(A2)

The result that i want it to produce is:

"How to use **Microsoft Excel**."

(where Microsoft Excel is in Bold Letters)

thanks.

Ad

I cant be 100% sure but the way spreadsheets work, you cant have two different fonts in 1 cell. they can kind of be thought of as having a "bold=true or false" kind of attribute. it can be either on or off but it cant be both

Posted on Oct 23, 2012

Ad

Hi,

Try selecting a cell and right click, Format cells, Font - Bold the text the way you want it to appear in that cell and then let it be the value you want to appear when you select that cell as a solution to a "What If" statement.

I build training spread sheets that let people generate pre-programmed answers to various data entries. Answers appear like magic.

Glad to be of assistance - please rate the posting - I can learn from you.

Posted on Oct 26, 2008

Ad

0helpful

1answer

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

1helpful

2answers

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

- All formulas begin with an equals sign
**(=)**. - Some formulas use operands such as
**+,-, *,/**for addition, subtraction, multiplication or division.

For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3. - Other formulas refer to different functions such as SUM, AVERAGE and others.

For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3. - Formulas can be
**combined with operands.**

For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10. - Functions can
**be nested within each other.**

For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 •
Microsoft EXCEL 2004 for Mac

2helpful

2answers

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

' 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

0helpful

2answers

Use the **test** function.

Formula in cell A1 would be**=text(a2,"dddd").**

This would pick up the date from cell A2 and return the day of the week in cell A1.

Formula in cell A1 would be

This would pick up the date from cell A2 and return the day of the week in cell A1.

Jun 06, 2010 •
Microsoft Excel for PC

0helpful

1answer

With data in A1 to C1:
A2 =IF(A1>0,1,0)
B2 =IF(B1>0,1,0)
C2 =IF(C1>0,1,0)
A3 =SUM(A2:C2)

Jun 04, 2009 •
Microsoft Office Excel 2007

1helpful

2answers

For the same exemple you can try this:

=COUNTIF(A1:A4,"=George Washington School")

=COUNTIF(A1:A4,"=George Washington School")

Apr 03, 2009 •
Microsoft Excel for PC

1helpful

1answer

The data series the the string of data you would like to have included in a formula or charted on a graph. For example, if you have data in cells A1, A2, and A3 and would like this data to be included in your formula or chart, it would be designated as A1:A3, translated as A1 through A3. This can most easily be accomplished by highlighting the data when the software is asking for the data series.

Nov 18, 2008 •
Microsoft Computers & Internet

0helpful

1answer

0helpful

2answers

for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 •
Microsoft Office Professional 2007:...

0helpful

2answers

The formula for A1 is: =SUM(B4,B5)

A2 is: =SUM(C4,C5)

A3 is: =SUM(A1:A2)

To test this, put 25 in cell B4, 25 in cell B5, then 30 in cell C4, and 30 in cell C5.....the result in cell A3 is 110.

Hope this helps.

A2 is: =SUM(C4,C5)

A3 is: =SUM(A1:A2)

To test this, put 25 in cell B4, 25 in cell B5, then 30 in cell C4, and 30 in cell C5.....the result in cell A3 is 110.

Hope this helps.

Mar 07, 2008 •
Microsoft Excel for PC

0answers

6,992 views

Usually answered in minutes!

i can't make it to produce the result that i wanted. doing the format cell, font-bold makes all of the contents

Boldand not only the words that i wanted.same I want only make bold a specific text within the string in the cell but I cant... how?

×