+ Reply to Thread
Results 1 to 2 of 2

posting day book details and how to enter multiple formulas in a single cell

  1. #1
    Registered User
    Join Date
    10-05-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    1

    Post posting day book details and how to enter multiple formulas in a single cell

    hi,

    I am chandra sekhar. I am not much professional in excel but i use it for my work. i had two problems to do my work , can anyone please help me out.
    Problem-1) i want to round off the digit in the same cell i,e. Formula in F12 should be included in D12.please help

    Problem-2) i have entered a sample account.in this i want to post the data entered in day book into their respective sheets of jaya and supervision automatically.please can anyone help me.
    Attached Files Attached Files

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,131

    Re: posting day book details and how to enter multiple formulas in a single cell

    Problem 1 In D12, type =ROUND(-IPMT($E$5,C12,$E$7,$C$6),0) and copy down.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Multiple Formulas in a single Cell
    By Shazz in forum Excel General
    Replies: 4
    Last Post: 01-10-2012, 07:02 AM
  2. posting multiple lines HTML into single cell
    By jrtaylor in forum Excel General
    Replies: 0
    Last Post: 06-09-2011, 01:57 PM
  3. Need multiple formulas in single cell
    By Deltaeagle in forum Excel General
    Replies: 2
    Last Post: 07-10-2009, 09:04 AM
  4. [SOLVED] How can I enter multiple paragraphs in a single Excel cell?
    By dclink9 in forum Excel General
    Replies: 2
    Last Post: 06-09-2006, 05:40 PM
  5. [SOLVED] Using a single cell in multiple formulas
    By ebethcat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-26-2005, 05:15 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