aqualiary
04-03-2014, 07:46 AM
Hi for example, this is my data
1 - - + + -
2 + + + - -
3 - - - - +
3 + + - - +
What i'm trying to do if a given row has at least 3 negative values, to replace all the negative values of the row to string "A" (for example). Only if a given row has 3 or more negative values, eg row 2 has only 2 negative values so I can just leave the row alone. (also all the negative values are the same, and all positive values are the same number and they are given as a string not an integer)
How do I go about doing this using IF statements, without worksheetfunction. (we were told to code it without using worksheetfunction)
1 - - + + -
2 + + + - -
3 - - - - +
3 + + - - +
What i'm trying to do if a given row has at least 3 negative values, to replace all the negative values of the row to string "A" (for example). Only if a given row has 3 or more negative values, eg row 2 has only 2 negative values so I can just leave the row alone. (also all the negative values are the same, and all positive values are the same number and they are given as a string not an integer)
How do I go about doing this using IF statements, without worksheetfunction. (we were told to code it without using worksheetfunction)