if again
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")
--
Regards
Roger Govier
"jam" wrote in message
oups.com...
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
|