Results 1 to 7 of 7

"IF" statements for text and numbers for financial summary

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-12-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    448

    "IF" statements for text and numbers for financial summary

    I have attached a spreadsheet. I would like to create the following sentence based on the numbers in the spreadsheet. I have problems with creating the If statements and the text. The numbers can be negative or positive depending on the results and this changes the words in the sentence. Thanks

    Our company reported a 20.8 Pretax profit (loss) for September which is 1.5 more (lower) than prior year and 3.6 higher (below) prior year.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Run Macros on all except "Summary" and "Reports" worksheets in a workbook
    By daralea in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-10-2013, 05:42 PM
  2. [SOLVED] Need Macro to compile data from "Weekly" sheets and sum up into "Monthly" summary sheet
    By mo4391 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-21-2013, 07:25 PM
  3. Replies: 9
    Last Post: 09-05-2012, 10:23 AM
  4. Replies: 3
    Last Post: 06-29-2012, 11:12 AM
  5. Replace numbers with Text ("1" to "Apple", for example)
    By pilotwings64 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-07-2008, 06:56 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