if and and calculations

[Jafferi]

A B C D
E
--------------------------------------------------------------------------------------
Delay Time | <15Min | 15-30Min| 31-45Min | 46-60Min | >1HR |
0:42
=====

In cell a, I have 0:42 as a timing of 42min. I need to produce a report that
for example in
column, if the Cell A is less than 42min, it will show as X, Cell C, it will
show as X, Cell D, it will show as Y and so on.

Please help to advise your expertise.

 

[Pete_UK]

Set up your first row like this:

Delay Time 00:15:00 00:30:00 00:45:00 01:00:00

(those are proper times in B1:E1). With 0:42:00 in A2, put this
formula in B2:

=IF($A2<B$1,"Y","x")

and copy this across (and down) as required.

Hope this helps.

Pete

 

[Jafferi]

Thank you but I would want to know how to get the results of 'in between' for
example

Cell A shows as 00:45, I want the results in Cell B to tell me if Cell A is
less than 00:45, give me X and if Cell A is BETWEEN 00:45 to 00:55 give me Y.

 

[Eduardo]

Hi,
try

=if(A1<00:45,X,Y)

Thank you but I would want to know how to get the results of 'in between' for
example

Cell A shows as 00:45, I want the results in Cell B to tell me if Cell A is
less than 00:45, give me X and if Cell A is BETWEEN 00:45 to 00:55 give me Y.

 

[Pete_UK]

Okay, put this formula in B2:

=IF($A2<B$1,"x",IF(AND($A2<C$1,$A2>B$1),"Y",""))

and copy across. It will give you this result:

Delay Time 00:15:00 00:30:00 00:45:00 01:00:00
02:00:00
00:43:00 Y
x x x

If that is not what you want then sketch it out in the same way. Refer
to proper cell addresses rather than "Cell A, Cell B etc".

Hope this helps.

Pete

 

[Pete_UK]

I see the formatting got messed up completely. See if this improves
it:

Delay Time 00:15 00:30 00:45 01:00 02:00
00:43:00 Y x x
x

Pete

 

[Jafferi]

It doesnt work. There are no error results as well.