if again

J

jam

Hi
I want to do this:
A B
Pay to 23 people 2006 Salery
Pay to 10 people 2006 Bonus
I want the column B to have the same string "salery" every time I write
pay to...
in order to filter at the end and make a balance
Using if, and nested if does not give the same string if I change the
number 23 to 50 for example
Any help? I would be grateful
Jam
 
R

Roger Govier

Hi

Not quite sure what you are after here.
Do you want
=IF(LEFT(A1,6)="Pay to","Salary","")
or
=IF((--(MID(A1,8,2))>=23,"Salary","Bonus")
 
J

jam

Hi Roger
Thank you very much for your swift and usuful solution and reply, I
used the left formula with if fuction. I have a problem, and it is
always the same, when I nest if function, it always give error formula,
no matter I check the brackets, and I just wrote exactly the formula of
if function in the help menu (not copy, write), and check it still
gives error, I have the impression that I am missing some information
about this nested functions, thanks in advance for help
Regards
Jam
 
R

Roger Govier

Hi Jam

Post back the formula you are actually using, and some ample data, then
we may be able to help you resolve the problem.
 
J

jam

Hi Roger
Thanks again, this is what I am trying to do
Salery 23 persons 2006 =if(LEFT(A1;6)="Salery", "Salery",
if(LEFT(A1;5)="Bank","Bank", if(LEFT(A1;9)="Insurance","Insurance",
if(LEFT(A1;7)="Hospital","Hospital","Others"))))
Bank 10 persons 2006
Insurance 30 persons 2006
Hospital 10 persons 2006
Th etext in column A and the formulae is B
Thank you for your help
Regards
Jam
 
R

Roger Govier

Hi Jam

Rather than using the IF statements you could just use
=LEFT(A1,FIND(" ",A1)-1)

It looks as though your regional settings are to use semicolon ";"
instead of comma "'" in which case for you it would be
=LEFT(A1;FIND(" ";A1)-1)

This formula looks for the first space in column A and takes everything
that occurs before it as the value in column B
 
J

jam

Hi Roger
YOU ARE A GENIUS
Thank you very very much for you permanent help
The formula worked beautifuly, and I checked the regional settings, you
are right
Thank again and regards
Jam
 
J

jam

Hi Roger
Another problem thanks for giving always swift and valuable solutions
A B
5 IF(0<a2<=3;"Pass";IF(a2=0;"OK"; "No"))
I want toa say Pass for the values 1 2 3
and OK for 0
And No for the values greater than 3
It gives only OK and No
Any help
Regards
Jam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top