Enter Data in either of 2 columns?

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")

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