+ Reply to Thread
Results 1 to 4 of 4

Getting an equation to apply to cells only with info in

  1. #1
    Registered User
    Join Date
    05-16-2014
    MS-Off Ver
    Excel 2003
    Posts
    30

    Getting an equation to apply to cells only with info in

    Do you know if there is anyway I can get an equation to only apply to cells with information in?....eg. I have two collums, one with 'disposal dates' in and the other with 'extended disposal dates'. I would like to get the difference between them (Extended disposal dates- disposal dates) however not all of them have an extended disposal date, therefore some cells display as '#VALUE!' because its calculating the disposal date-blank cell.... How can i get round this?

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Getting an equation to apply to cells only with info in

    Column A Disposal Date
    Column B Extended disposal date

    in C1
    =IF(AND(A1<>"",B1<>""),B1-A1,"")
    and copy down the column
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Getting an equation to apply to cells only with info in

    Test it

    =IF(OR(Extended_disposal_dates="",disposal_dates=""),"",Extended_disposal_dates- disposal_dates)

  4. #4
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Getting an equation to apply to cells only with info in

    =IFERROR((Extended disposal dates- disposal dates),"")

    OR

    =IFERROR((Extended disposal dates- disposal dates),0)

+ 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. Replies: 5
    Last Post: 06-01-2012, 05:04 PM
  2. Conditionally apply a math equation to cell
    By joshd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2010, 01:24 AM
  3. Search for info and copy found info to specific cells
    By Costas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-19-2010, 07:12 AM
  4. Replies: 1
    Last Post: 02-21-2006, 10:30 PM
  5. using cell info in an equation... Very frusterated
    By miwarren in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2005, 03: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