+ Reply to Thread
Results 1 to 5 of 5

If Function Help

  1. #1
    Registered User
    Join Date
    08-19-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    3

    If Function Help

    I'm almost embarrassed to ask this, so please no laughing...

    Simple spreadsheet:
    Column D - used to input the date in which an item sold. Left blank until item is sold.
    Column E - contains the price we paid to purchase item.
    Column F - contains the price we sold the item sold for.
    Column G - I want this to show our profit (F-E), but only if there is a date in D.

    This is what I have so far, but I keep getting FALSE:

    =IF(ISBLANK(D6),IF(D6>0,F6-E6,0))

    Please help! It's been quite some time since I have used Excel, but it's like riding a bike, right??

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: If Function Help

    Hello Lisamll & Welcome to the Forum,

    =IF(N(D6),F6-E6,0)

    The N function is just checking D6 to see if it is a Date which is a number.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    08-11-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    6

    If Function Help

    =if(isblank(d6),0,f6-e6)



    if this helped kindly add to reputation KINDLY CLOSE YOUR POST MARKING SOLVED
    Last edited by john321; 08-19-2013 at 10:19 PM.

  4. #4
    Registered User
    Join Date
    08-19-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: If Function Help

    That worked! Thank you so much!!

  5. #5
    Registered User
    Join Date
    08-19-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: If Function Help

    Thank you for your help!

+ 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. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  2. [SOLVED] Using Offset function as the array in the PercentRank function is giving wrong result
    By Bobneil in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-06-2013, 09:29 PM
  3. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  4. Replies: 2
    Last Post: 03-20-2009, 01:29 PM
  5. Excel - User Defined Function Error: This function takes no argume
    By BruceInCalgary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2006, 04:05 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