Multiple data entry with multiple results

  • Thread starter Thread starter Jafferi
  • Start date Start date
J

Jafferi

How do I do a multiple data entry with different results

Cell A1 is the Data Entry cell.
Cell J1 is the result cell.

If I enter the word K in A1, J1 shows as 7:00
If I enter 9:00; J1 shows the same that is 9:00
 
You've only described two entry possibilities..."K" and everything else. An
IF will take care of that:

=IF(A1="K","7:00",A1)

....but if you want to keep adding "varying" responses, you'll run out of IF
levels...or it will just get too cumbersome to read.
 
Hi,

You question is not completely clear. In J1 enter

=IF(A1="K",7,9)/24

Format J1 to the time formula you want.

Or you may want

=IF(A1="K",7/24,A1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining several cells into single equasion? 1
More Than VLOOKUP() 11
separating date and time 5
Date/Time 1
Summing a variable range of columns 9
count function ??? 2
How to supress result (39411) of Fn =TODAY()-J1 when J1 is blank 3
How to set cell value to emptry if three other columns are empty too 1

Back
Top