Results 1 to 12 of 12

Reverse Calculation

Threaded View

  1. #1
    Forum Contributor leo73pk's Avatar
    Join Date
    09-28-2006
    Location
    UAE
    MS-Off Ver
    2016, Microsoft 365
    Posts
    294

    Thumbs up Reverse Calculation

    I created a following formula to convert the number of balls bowled in a match to a number of overs in that match.

    Logic: 1 over = 6 balls

    Whereas “bb” is the cell reference wherein we insert number of balls bowled in a match.

    Formula =INT(bb/6)+(bb/6-INT(bb/6))*6/10
    The formula works fine to calculate number of overs accurately i.e. 36 balls equivalent to 6 overs similarly if we put 39 balls it converts to 6.3 Overs

    Now I want a formula that perform a reverse calculation to calculate number of balls for any number of overs (based on the same logic that 1 over =6 balls)
    Last edited by leo73pk; 06-26-2010 at 04:40 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1