Results 1 to 5 of 5

Is populating one cell based on its unfilled pair possible?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-25-2014
    Location
    Pennsylvania, US
    MS-Off Ver
    Windows '16
    Posts
    165

    Is populating one cell based on its unfilled pair possible?

    I'm trying to populate one of two cells, whichever is blank, with data based on the second. For example,

    .............A................B..............C
    ...........................Monthly......Annually
    1.....Line item 1.......___...........___
    2.....Line item 2.......___...........___
    3.....Line item 3.......___...........___
    ....

    Where data could be entered into either column B or C, and the other column will perform the appropriate calculation (multiple/divide by 12). And I'm trying to get this to stay in place, so that cell values can be changed repeatedly and the corresponding cell will change automatically.

    Is this possible?

    Thanks.
    Last edited by JYTS; 08-25-2014 at 07:48 AM. Reason: fixed my ugly table

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