Displaying text depending on result from other formula

[likma]

Hello all,

I need a help, it might be very simple, but I can't solve it.
Problem: I have a cell D1, that calculates time from other cells, and depending on the result, I need cell D2 to show text.

Example:
If time in cell D1 is less than 8:00 hours, Cell D2 would show "Text 1"
If time in cell D1 is more than 8:00, but less than 12:00 hours, Cell D2 would show "Text 2"
If time in cell D1 is more than 12:00 hours, Cell D2 would show "Text 3"

Thanks.

[arthurbr]

Hi and welcome to the board

Do you mean you have a number of hours in D1 or date and time?

[teylyn]

Hello,

set up a lookup table like this, for example starting in cell G1

Please Login or Register  to view this content.

Then you can use this formula in D2

=VLOOKUP(D1,G1:H3,2,TRUE)

It's not quite clear what you want to display for exactly 8:00 and 12:00, so you may want to edit the table to show 8:01 and 12:01, depending on what result you prefer.

cheers,

[likma]

Thank you very much, it helps.

And yes, it's only hours in D1.