Combining IF AND & FIND Functions
 

Hi all

I've been trying to solve this one for a week and am just getting nowhere,
any help would be greatly appreciated.

I have a list of shops in column A and a list of total sales figures in
column B, Some of the shops in Column A are chains and so have multiple
entries (think WH Smiths, Borders etc...). I'm trying to write a formula that
will check to see if the Characters WHS are in column A and see if the figure
in Column B is greater than 15000, and if so enter "Sales OK" otherwise enter
"NON Chain". The best I could come up with is
=if(and(find("WHS*",a2)b215000,"Sales OK","NON Chain")) but it doesn't work.
Help!!!!!

Combining IF AND & FIND Functions
 

Hi

Try this:
=IF(AND(ISNUMBER(FIND("WHS",A2)),B215000),"Sales OK","NON Chain")
Please note that FIND is case-sensitive, so WHS must be in capitals.

Andy.


"Steve" wrote in message
...
Hi all

I've been trying to solve this one for a week and am just getting nowhere,
any help would be greatly appreciated.

I have a list of shops in column A and a list of total sales figures in
column B, Some of the shops in Column A are chains and so have multiple
entries (think WH Smiths, Borders etc...). I'm trying to write a formula
that
will check to see if the Characters WHS are in column A and see if the
figure
in Column B is greater than 15000, and if so enter "Sales OK" otherwise
enter
"NON Chain". The best I could come up with is
=if(and(find("WHS*",a2)b215000,"Sales OK","NON Chain")) but it doesn't
work.
Help!!!!!

Combining IF AND & FIND Functions
 

Thanks Andy, ISNUMBER hadn't entered my thoughts - that works

Steve

"Andy" wrote:

Hi

Try this:
=IF(AND(ISNUMBER(FIND("WHS",A2)),B215000),"Sales OK","NON Chain")
Please note that FIND is case-sensitive, so WHS must be in capitals.

Andy.


"Steve" wrote in message
...
Hi all

I've been trying to solve this one for a week and am just getting nowhere,
any help would be greatly appreciated.

I have a list of shops in column A and a list of total sales figures in
column B, Some of the shops in Column A are chains and so have multiple
entries (think WH Smiths, Borders etc...). I'm trying to write a formula
that
will check to see if the Characters WHS are in column A and see if the
figure
in Column B is greater than 15000, and if so enter "Sales OK" otherwise
enter
"NON Chain". The best I could come up with is
=if(and(find("WHS*",a2)b215000,"Sales OK","NON Chain")) but it doesn't
work.
Help!!!!!

Combining IF AND & FIND Functions
 

Thanks for the feedback!

Andy.

"Steve" wrote in message
...
Thanks Andy, ISNUMBER hadn't entered my thoughts - that works

Steve

"Andy" wrote:

Hi

Try this:
=IF(AND(ISNUMBER(FIND("WHS",A2)),B215000),"Sales OK","NON Chain")
Please note that FIND is case-sensitive, so WHS must be in capitals.

Andy.


"Steve" wrote in message
...
Hi all

I've been trying to solve this one for a week and am just getting
nowhere,
any help would be greatly appreciated.

I have a list of shops in column A and a list of total sales figures in
column B, Some of the shops in Column A are chains and so have multiple
entries (think WH Smiths, Borders etc...). I'm trying to write a
formula
that
will check to see if the Characters WHS are in column A and see if the
figure
in Column B is greater than 15000, and if so enter "Sales OK" otherwise
enter
"NON Chain". The best I could come up with is
=if(and(find("WHS*",a2)b215000,"Sales OK","NON Chain")) but it doesn't
work.
Help!!!!!