if and and calculations

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

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.
 
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
 
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.
 
Hi,
try

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


Jafferi said:
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.
Click to expand...
 
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
 
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
 
Back
Top