+ Reply to Thread
Results 1 to 4 of 4

Help with formula (tetens equation)

  1. 03-17-2022, 01:38 PM #1
    swemek
    swemek is offline
    Registered User
    Join Date
    03-25-2021
    Location
    Sweden
    MS-Off Ver
    2016
    Posts
    2

    Help with formula (tetens equation)

    Hey!
    Need help writing this formula in Excel.
    Can't make it work!
    Please help !!!


    Formula.jpeg
    Reply With QuoteRegister To Reply
  2. 03-17-2022, 02:53 PM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,196

    Re: Help with formula (tetens equation)

    Try

    =0.61078*EXP((17.27*A1)/(A1+237.3))

    A1=Temperature
    Last edited by JohnTopley; 03-17-2022 at 03:09 PM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 03-17-2022, 03:46 PM #3
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Help with formula (tetens equation)

    With T in A1

    =0.61078*EXP(1)^((17.27*A1)/(A1+237.3))

    Edit....Ah, I see John beat me to it whilst I was having dinner!
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  4. 03-18-2022, 02:09 AM #4
    swemek
    swemek is offline
    Registered User
    Join Date
    03-25-2021
    Location
    Sweden
    MS-Off Ver
    2016
    Posts
    2

    Re: Help with formula (tetens equation)

    Thanks so much!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cannot convert VLOOKUP equation into a range equation
    By alecoute in forum Excel General
    Replies: 3
    Last Post: 02-07-2020, 09:47 AM
  2. Change variables within an equation without the equation forgetting the previous variable
    By GarethmMorgan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2018, 01:48 PM
  3. dragging an equation but only changing one part of the equation
    By mufan in forum Excel General
    Replies: 3
    Last Post: 04-09-2012, 01:36 PM
  4. Need an equation to index match based on a criteria, Within another equation...
    By 00Able in forum Excel General
    Replies: 4
    Last Post: 02-02-2012, 10:11 PM
  5. Discrepancy between data analysis regression equation and linear trendline equation
    By Marinegirl in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-06-2011, 01:38 PM
  6. excel equation (user defined equation)
    By excel_student in forum Excel General
    Replies: 0
    Last Post: 03-10-2005, 03:59 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1