Enter Data in either of 2 columns?

TomG9876 · #1 12-02-2015, 06:04 AM

I would like to enter data in either of two columns and have it appear in the other. Consider a vacation spreadsheet. If "Column A" were hours and "Column B" were Days I would like to enter "8" in "Column A" and have "1" appear in "Column B"; or I would like to enter "3" in "Column B" and have "24" appear in "Column A". How can I do this without getting a circular error?

Thanks Tom G

shg · #2 12-02-2015, 11:11 AM

Welcome to the board.

That would require VBA.

You could instead use columns A & B as input, and C & D to calculate:

Code:

   --A-- -B-- --C-- --D--
1   Hours Days Hours Days
2      16         16     2
3            3    24     3
4       1    1 Error Error

C2 and down: =CHOOSE(ISNUMBER(A2) + 2 * ISNUMBER(B2) + 1, "", A2, 8 * B2, "Error")

D2 and down: =CHOOSE(ISNUMBER(A2) + 2 * ISNUMBER(B2) + 1, "", A2 / 8, B2, "Error")

TomG9876 · #3 12-02-2015, 01:32 PM

Thanks! I have programmed a little in Access, but never Excel. I guess I should try.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
combining 2 or more columns of numerical data or text data	heartdoc	Excel	0	12-03-2014 10:57 PM
why am i able to enter data into baseline	ketanco	Project	3	08-22-2014 08:10 AM
A table that expands as you enter in data	OMC	Word	2	02-05-2013 03:27 PM
Cannot enter data in certain columns of tables	HipHopapotamus	Word Tables	1	05-02-2011 06:57 PM
Is there a way to do this? (automatically enter text based on form data)	TIKKI555	Word	0	05-26-2010 09:21 AM