Results 1 to 3 of 3

Conditional Function Help

Threaded View

  1. #1
    Registered User
    Join Date
    09-16-2011
    Location
    Minnesota
    MS-Off Ver
    Excel 2007
    Posts
    30

    Conditional Function Help

    Hi, I have a spreadsheet which occasionally has cells with empty data. The spreadsheet is downloaded daily from an online table so I don't always know where the empty cells are placed (see column A in attached example). I need to write a formula to calculate return data in column B. So far, the best I have is =IF(AND(A3<>"",A2<>""),A3/A2-1,"") but this does not generate the desired result.

    I need help with the first part of the formula. For example, if cell A4 has data but A3 does not have data, I then want the formula to use A2 to calculate returns. For example, (A4/A2-1,""). If A3 has data, then the formula should read (A4/A3-1,"")
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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