IF with nested AND
Bob Hi and thanks for your prompt responce, both forumals work ok
I have tried to amend the SUMPRODUCT formular for something else without
success
I am trying to put a symbol in a collumn where a cell E14 equals names in
P17:P24, all fields are text names.
If you could assist me with this it would be appreciated
Thanks Joco (London)
"Bob Phillips" wrote:
=IF(AND(--"06:00:00"<C1575,C1575<--"18:00:00"),5,3)
=SUMPRODUCT(--(ISNUMBER(MATCH(E10:E1600,E1609:E1615,0))),K10:K16 00)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Joco" wrote in message
...
Hi,
Can you please tell me how to put a symbol on a line, if a time is before
or
after a specified time. I have tried the following which is a valid
formula,
but does not give me the correct answer.
=IF(AND("06:00:00"<C1575,C1575"18:00:00"),5,3) (the relevant field is
formatted to monotype sorts to give either a tick or a cross)
I am also trying to produce an IF formula that looks at a block of cells,
I
have tried the following, which only works for the first cell in the block
=SUMIF(E10:E1600,E1609:E1615,(K10:K1600))
The E1609:E1615 contains text names
Any help would be really appreciated, thanks
Joco (London)
|