+ Reply to Thread
Results 1 to 6 of 6

two formulas in one cell

  1. #1
    Registered User
    Join Date
    05-27-2014
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    15

    two formulas in one cell

    i have used =D2/(B2^12) formula and i want the answer in 2 decimal places using round function i dont know how to use two formulas in one cell please reply fast
    Attached Files Attached Files

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: two formulas in one cell

    Try

    =ROUND(D2/(B2^12),2)

  3. #3
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: two formulas in one cell

    =round(d2/(b2^12),2)
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  4. #4
    Registered User
    Join Date
    05-27-2014
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    15

    Re: two formulas in one cell

    sorry solved thankyou very much)

  5. #5
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: two formulas in one cell

    You're welcome.

  6. #6
    Registered User
    Join Date
    05-27-2014
    Location
    Pakistan
    MS-Off Ver
    2007
    Posts
    15

    Re: two formulas in one cell

    solved thanks

+ 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. Using Cell references in file paths for formulas to create dynamic formulas
    By MichaelStokesJr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2013, 11:49 AM
  2. View cell info instead of formulas / Evaluate formulas
    By whitetea in forum Excel General
    Replies: 2
    Last Post: 05-20-2012, 10:08 AM
  3. Excel 2007 : Future Date Formulas and Adjacent Cell Formulas
    By thetaylor13 in forum Excel General
    Replies: 4
    Last Post: 02-09-2011, 04:33 PM
  4. Multiple formulas in selected cell without damaging previous formulas.
    By excel5111987 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-05-2011, 06:15 AM
  5. Replies: 5
    Last Post: 05-05-2008, 02:22 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1