Multiple inputs one output

  • Thread starter Chris W via OfficeKB.com
  • Start date
C

Chris W via OfficeKB.com

What could I use to enable one cell to have a value that is controlled by
multiple options, but only one of them will be filled in but will vary each
time.

For instance, A1,A2,A3 are amounts of something that will be filled in and
variable. Only one will be entered. I need the amount in A1,A2,or A3 to
then be entered into G12 on another worksheet.

Thanks for any help.
 
S

StinkeyPete

Quick and dirty method (Assumes that one one of the three fields will have
input, otherwise it will show all of the data entered)

In cell G12 enter

=VALUE(A1&B1&C1) if it is going to be text then enter

=(A1&B1&C1)

HTH

this will return a value
 
Top