IF with nested AND
Not sure I understand. All ranges must be similar sized, you can't have a 10
row range for one test and a 25 row range for another.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Joco" wrote in message
...
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)
|