India Broadband Forum


Add overs in Excel

This is a discussion on Add overs in Excel within the Computer hardware and software tips and tricks forums, part of the News and views category; Hi All, I know most of the Indians are very much cricket enthusiastic. Did you ever try to add the ...

Go Back   India Broadband Forum > General > General offtopic discussions > News discussions > News and views > Computer hardware and software tips and tricks

India Broadband Forum


Computer hardware and software tips and tricks Tips, tricks, and how-to's that help you get the most from your computer gear.Visit our Computer Tips And Tricks section

                      

Reply

 

LinkBack Thread Tools Display Modes
Old 11-25-08, 07:57 AM   #1
Junior Member
 
Join Date: Oct 2008
Posts: 3
Rep Power: 0
krishnakrkc is on a distinguished road
Default Add overs in Excel

Hi All,

I know most of the Indians are very much cricket enthusiastic. Did you ever try to add the overs in Excel? Here is a way to calculate the overs in Cricket.


B C D
4 Overs
5 Z Khan 9.4 9.67
6 Ishant 8 8.00
7 Harbhajan 10 10.00
8 Yuvraj 4.2 4.33
9 Sachin 5.4 5.67
10 Munaf 10 10.00
11 Total Over 47.4

Spreadsheet Formulas
Cell Formula
D5 =DOLLARDE(C5,6)
D6 =DOLLARDE(C6,6)
D7 =DOLLARDE(C7,6)
D8 =DOLLARDE(C8,6)
D9 =DOLLARDE(C9,6)
D10 =DOLLARDE(C10,6)
D11 =DOLLARFR(SUM(D5: D10),6)

You must need to install Analysis Toolpak add-in via Tools > Add-Ins > check Analysis Toolpak.


Now see some of the formulas;

To find the last numeric in a range (A1:A100), the formulas would be

=LOOKUP(9.999999999999E+307,A1;A100)

Now 9.99999999999E+307 is the biggest number one can enter in Excel

So to find the last string,

=LOOKUP(REPT(“z”,255),A1:A100)

Now to find the last non-zero value,

=LOOKUP(2,1/(A1:A100<>0),A1:A100)

So to find the first non-zero value

=INDEX(A1:A100,MATCH(1,(A1:A100)<>0,0))

Array Entered.

I hope this would be handy to you all

BTW, I'm not allowing to post html code to represent the Excel sheet over here.
krishnakrkc is offline   Reply With Quote
Reply

Tags
add, excel, overs

Thread Tools
Display Modes

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
Excel Games.... Dragon Videogaming News and Reviews 55 11-11-09 04:19 PM
Excel Workshop smoothvibes Windows 1 12-19-08 04:31 AM
Free Excel Mobile SIM for EXRA customers India Broadband Internet India Broadband and Telecom News 0 08-23-06 10:26 AM
Level 10 Security Alert: Microsoft Excel Zero-day Vulnerability Admin PR Releases Database 0 06-26-06 03:58 AM
Microsoft working on fixing the MS Excel security glitch Admin Software News, Previews and Reviews 0 06-25-06 06:11 PM


All times are GMT +5.5. The time now is 03:45 AM.


India Broadband Forum