question

[curtisw]

anyone knows?

thanks.

 

[T. Valko]

how to formulate it in excel 2002?

thanks

Works just fine for me in Excel 2002:

Book1
	A	B	C
1	I am happy	_	so happy
2	I am sad	_	so sad
Sheet1

This formula entered in C1 and copied down:

=IF(ISNUMBER(FIND("happy",$A1)),"so happy",IF(ISNUMBER(FIND("sad",$A1)),"so sad",""))

 

[curtisw]

Thank you.

The if function can be used for how many times? If I use it for many times, does it show error?

 

[wigi]

Thank you.

The if function can be used for how many times? If I use it for many times, does it show error?

It depends on the Excel version that you are using.

In general, some sort of lookup table and ditto function are preferred over a lot of nested IF's.

 

[curtisw]

It depends on the Excel version that you are using.

In general, some sort of lookup table and ditto function are preferred over a lot of nested IF's.

thanks xd

Here comes to another question....

A1. B1 shows A1
A2. B2 shows A2

When I paste the formular to other cell, say B5
A5. B5 shows A1
A6 B6 shows A2

How to formulate it if I paste it in B5, but shows A5?

Thanks.
Sorry that I have so many questions...

 

[wigi]

What is the formula in cell B1? Do you use $ to have absolute references rather than relative references?

 

[curtisw]

What is the formula in cell B1? Do you use $ to have absolute references rather than relative references?

i didnt use $ for the formular
I have tried to use the above formular without $
It didn't work

Excel 2002

 

[wigi]

Is the calculation mode in Excel on automatic or manual?

What happens, after that you pasted the formulas to other cells, if you press the F9 button?

 

[curtisw]

this image shows the problem that doesnt work

hit F9

 

[curtisw]

 

[curtisw]

help~~