+ Reply to Thread
Results 1 to 3 of 3

Excel formula - If function (maybe?)

  1. #1
    Registered User
    Join Date
    09-10-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    2

    Angry Excel formula - If function (maybe?)

    I'm looking for the cell directly below the most recent data input to show the difference in values for the two cells above.

    Column A has dates, columns B & C have Gain/loss in USD and % respectively, D: market value, E: total cost, as depicted below (value are obviously simply for representation)

    So potential formula for B4 would include the following arguments
    - If A3 has a value and A4 is blank then calculate formula '=B3-B2'
    - If both A3 & A4 have values then calculate formula '=D4-E4'
    - If both A3 & A4 are blank leave cell value at '-'


    A B C D E
    1 Date Gain/Loss ($) Gain/Loss (%) Value Cost
    2 9/08 $10 3% $20 $10
    3 9/09 $12 3.5% $22 $10
    4 Blank $2.0 0.5% - -
    5 Blank - - - -


    Currently I am using '=IF(OR(A#=""),"-",(D#-E#))' to calculate USD and % gain/loss if there's a date value present in column A and to leave as '-' if blank.
    Last edited by bluewolf815; 09-10-2012 at 02:19 PM. Reason: table formatting

  2. #2
    Registered User
    Join Date
    07-29-2010
    Location
    Indiana
    MS-Off Ver
    Excel 2003, 2010, 2013
    Posts
    51

    Re: Excel formula - If function (maybe?)

    Try this formula for cell B4

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-10-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Excel formula - If function (maybe?)

    Worked perfectly! Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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