Question about Microsoft Excel 2000 Step by Step (1572319747) for PC

1 Answer

Microsoft Excel Calculation

I'm looking for a formula that will allow me to calculate the total of the lowest two cells from any 3 cells in a row

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 8 Answers

For example if your numbers are in cells A1, B1 and C1
=MIN(A1:C1)+MEDIAN(A1:C1)

only works for 3 numbers as you requested.

Posted on Nov 07, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

What is the calculation of 6:12


It is a ratio. Simplified it is 1:2.

So we can say x:y is as 1:2, or y = 2x

Hope that assists.

Oct 01, 2014 | Educational & Reference Software

1 Answer

Why did i choose microsoft excel lab?


To create some spread sheet of datas.
Crate some Commercial calculation as well as Graphical charts such as pie chart,bar chart .
Excel is ocean bro.

Jul 09, 2014 | Educational & Reference Software

2 Answers

I NEED MS EXCEL CONVERT FORMULA FOR NUMBER TO CURRENCY


Here is a very popular bit of code from Microsoft that will convert any currency amount in a cell to English words. All code and text from below here is the work of Microsoft.

Summary
This article shows you how to create a sample, user-defined function named ConvertCurrencyToEnglish() to convert a numeric value to an English word representation. For example, the function will return the following words for the number 1234.56: One Thousand Two Hundred Thirty Four Dollars And Fifty Six Cents

The Function Wizard can also be used to enter a custom function in a worksheet. To use the Function Wizard, follow these steps:

1. Click the Function Wizard button, and select User Defined under Function Category.
2. Select ConvertCurrencyToEnglish, and enter your number or cell reference.
3. Click Finish

To Create the Sample Functions

1. Insert a module sheet into a workbook. To do this in Microsoft Excel 97 or Microsoft Excel 98, point to Macro on the Tools menu, and then click Visual Basic Editor. In the Visual Basic Editor, click Module on the Insert menu. In Microsoft Excel 5.0 or 7.0, point to Macro on the Insert menu and click Module.

2. Type the following code into the module sheet.
Function ConvertCurrencyToEnglish (ByVal MyNumber)

Dim Temp

Dim Dollars, Cents

Dim DecimalPlace, Count



ReDim Place(9) As String

Place(2) = " Thousand "

Place(3) = " Million "

Place(4) = " Billion "

Place(5) = " Trillion "



' Convert MyNumber to a string, trimming extra spaces.

MyNumber = Trim(Str(MyNumber))



' Find decimal place.

DecimalPlace = InStr(MyNumber, ".")



' If we find decimal place...

If DecimalPlace > 0 Then

' Convert cents

Temp = Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2)

Cents = ConvertTens(Temp)



' Strip off cents from remainder to convert.

MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))

End If



Count = 1

Do While MyNumber <> ""

' Convert last 3 digits of MyNumber to English dollars.

Temp = ConvertHundreds(Right(MyNumber, 3))

If Temp <> "" Then Dollars = Temp & Place(Count) & Dollars

If Len(MyNumber) > 3 Then

' Remove last 3 converted digits from MyNumber.

MyNumber = Left(MyNumber, Len(MyNumber) - 3)

Else

MyNumber = ""

End If

Count = Count + 1

Loop



' Clean up dollars.

Select Case Dollars

Case ""

Dollars = "No Dollars"

Case "One"

Dollars = "One Dollar"

Case Else

Dollars = Dollars & " Dollars"

End Select



' Clean up cents.

Select Case Cents

Case ""

Cents = " And No Cents"

Case "One"

Cents = " And One Cent"

Case Else

Cents = " And " & Cents & " Cents"

End Select



ConvertCurrencyToEnglish = Dollars & Cents

End Function







Private Function ConvertHundreds (ByVal MyNumber)

Dim Result As String



' Exit if there is nothing to convert.

If Val(MyNumber) = 0 Then Exit Function



' Append leading zeros to number.

MyNumber = Right("000" & MyNumber, 3)



' Do we have a hundreds place digit to convert?

If Left(MyNumber, 1) <> "0" Then

Result = ConvertDigit(Left(MyNumber, 1)) & " Hundred "

End If



' Do we have a tens place digit to convert?

If Mid(MyNumber, 2, 1) <> "0" Then

Result = Result & ConvertTens(Mid(MyNumber, 2))

Else

' If not, then convert the ones place digit.

Result = Result & ConvertDigit(Mid(MyNumber, 3))

End If



ConvertHundreds = Trim(Result)

End Function







Private Function ConvertTens (ByVal MyTens)

Dim Result As String



' Is value between 10 and 19?

If Val(Left(MyTens, 1)) = 1 Then

Select Case Val(MyTens)

Case 10: Result = "Ten"

Case 11: Result = "Eleven"

Case 12: Result = "Twelve"

Case 13: Result = "Thirteen"

Case 14: Result = "Fourteen"

Case 15: Result = "Fifteen"

Case 16: Result = "Sixteen"

Case 17: Result = "Seventeen"

Case 18: Result = "Eighteen"

Case 19: Result = "Nineteen"

Case Else

End Select

Else

' .. otherwise it's between 20 and 99.

Select Case Val(Left(MyTens, 1))

Case 2: Result = "Twenty "

Case 3: Result = "Thirty "

Case 4: Result = "Forty "

Case 5: Result = "Fifty "

Case 6: Result = "Sixty "

Case 7: Result = "Seventy "

Case 8: Result = "Eighty "

Case 9: Result = "Ninety "

Case Else

End Select



' Convert ones place digit.

Result = Result & ConvertDigit(Right(MyTens, 1))

End If



ConvertTens = Result

End Function







Private Function ConvertDigit (ByVal MyDigit)

Select Case Val(MyDigit)

Case 1: ConvertDigit = "One"

Case 2: ConvertDigit = "Two"

Case 3: ConvertDigit = "Three"

Case 4: ConvertDigit = "Four"

Case 5: ConvertDigit = "Five"

Case 6: ConvertDigit = "Six"

Case 7: ConvertDigit = "Seven"

Case 8: ConvertDigit = "Eight"

Case 9: ConvertDigit = "Nine"

Case Else: ConvertDigit = ""

End Select

End Function

Apr 15, 2010 | Broderbund Learn MS Windows XP and Excel...

2 Answers

Bank process in daily interest calculation


I want how i can calculate daily profit /loss calculation on investment

Sep 07, 2009 | Microsoft Step by Step Visual Basic 6.0...

2 Answers

Excel wont calculate when changes are made to an existing file.


Looks like you will have to re-install Excel from original CD again.

May 28, 2009 | Microsoft Excel 2000 Step by Step...

1 Answer

FORMULA FOR FINDING PERCENTAGE


find "fx" on your toolbar; choose all formulas find percentage, you can set a specific percentage to the cell, just put the number you want a percentage of or if you want to keep that number, put the percentage formula in the next cell <%a:2>

Apr 16, 2009 | Educational & Reference Software

1 Answer

Fractions how to


Hi Dear, there are several solutions
  • In ms excel type a fraction formula and in tools--> formula auditing -->
  • Please download offcemath.msi for MS Word 2007 from www.office.microsoft.com and install it.
    its calculator part will show you the steps of solving fractions in insert--> equations-->maths.
  • Alternatively you can download microsoft math trial from www.microsoft.com this will show you all steps.
Zulfikar Ali
ali_zulfikar@yahoo.com
9899780221

Mar 04, 2009 | Core Learning Fractions Step-By-Step...

1 Answer

Weight loss formula


Open excel and do the following...

A1: Weekly Entry B1: Weekly loss C1:Total loss
A2: Enter pound B2: Nothing Yet C2: Nothing Yet
A3: Enter pound B3:=if(a3="","",a2-a3) C3: =if(a3="",'',b3-b2)

Last thing you need to do is copy the cells A3,B3, and C3 and paste to the next row for every week.

Feb 24, 2009 | The Learning Company Achieve! Math &...

1 Answer

Mathematical Calculation


Following formula we can use.

S=P(1+RT)
WHERE S =INVEST AMOUNT+PROFIT
P=INVEST AMOUNT
R= RATE OF RETURN
T=TIME IN YEARS

EX : (300+x) = x(1+(5.4/100)*1)
(300+x)*100 = 105.4x
x=30000/5.4
x=5555. 4

Jan 05, 2008 | The Learning Company Achieve! Math &...

Not finding what you are looking for?
Microsoft Excel 2000 Step by Step (1572319747) for PC Logo

141 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Educational & Reference Software Experts

k24674

Level 3 Expert

7987 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18304 Answers

Are you a Microsoft Educational and Reference Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...