+ Reply to Thread
Results 1 to 6 of 6

Development of a exel input formula for microbiology

  1. #1
    Registered User
    Join Date
    06-05-2012
    Location
    Cape Town
    MS-Off Ver
    Excel 2010
    Posts
    23

    Question Development of a exel input formula for microbiology

    Tried to open the formulation area of the forum but get an error so posting here and when that is working I can move it.
    I need to develop a formula that is used in our microbiology laboratory and the formula on paper is attached as I needed scientific symbols.
    total plate count formula.JPG
    Last edited by fionaby; 07-10-2014 at 11:40 AM.

  2. #2
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├•┤ Pew Pew
    Posts
    441

    Re: Formulation assistance

    What exactly is it that you need? A formula in excel that takes these as inputs and calculates, or to just show that formula with the summation symbol, etc as shown in your picture?
    Despite the high cost of living, it remains very popular.

    Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!

  3. #3
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Formulation assistance

    not sure but maybe
    a1=value of n1
    a2= value of n2
    a3= value of dilution factor
    a4= sum of colonies value
    =$A$4/(($A$1+0.1*$A$2)*$A$3)
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Formulation assistance

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  5. #5
    Registered User
    Join Date
    06-05-2012
    Location
    Cape Town
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Development of a exel input formula for microbiology

    Yes we would input the result and it would preform the calculation. I will link the current spreadsheet but being locked and the developer is not able to be contacted we want to simplify this report and update it.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    06-05-2012
    Location
    Cape Town
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Formulation assistance

    Quote Originally Posted by martindwilson View Post
    not sure but maybe
    a1=value of n1
    a2= value of n2
    a3= value of dilution factor
    a4= sum of colonies value
    =$A$4/(($A$1+0.1*$A$2)*$A$3)
    Thanks will give this a try. Have attached a spreadsheet with the current calculations.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. COUNTIF formulation
    By digitalboy40 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-11-2013, 02:18 PM
  2. DAy FORMULATION
    By bginn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-11-2013, 01:03 PM
  3. Formulation Question
    By bsp12 in forum Excel General
    Replies: 2
    Last Post: 05-21-2012, 02:52 AM
  4. RE: If formulation: Is it possible...
    By OSCAR in forum Excel General
    Replies: 3
    Last Post: 12-31-2005, 03:55 AM
  5. [SOLVED] If formulation
    By OSCAR in forum Excel General
    Replies: 2
    Last Post: 12-31-2005, 02:10 AM

Tags for this Thread

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