Assigning value to text
On 22 Sep, 14:25, Stefi wrote:
Enter
=IF(A1="NO CHANGE",10,20)
and drag it down to A100.
Regards,
Stefi
„Robincambs” ezt írta:
I am looking to assign a value to a text string and then insert the
corresponding value into a cell
As follows:
A1 to A100 could equal "NO CHANGE" or "FOR CHANGE"
If A1 = "NO CHANGE" then I1 = "10" else if A1 = "FOR CHANGE" then I1 =
"20"
If A2 = "NO CHANGE" then I2 = "10" else if A2 = "FOR CHANGE" then I2 =
"20"
then this to loop until A100
any help will be gratefully received- Hide quoted text -
- Show quoted text -
Unfortunatly neither of those work - perhaps its due to me using
conditional formatting or dropdown lists?
|