Hello,
I don't know if this can be done via Excel formula, or VBA, but I have an if statement in one column that will return the number "1" if the condition is true.
I.e. J10 = 1 as C10 is true to the condition.
I'm importing the cell C10 so it's always changing, so a formula would be wiped out, however if J10 is true (and equal to "1"), I'd like C10 to read "TOTAL".
Hopefully this makes sense. I was thinking of placing some sort of statement in column K (K10?) that if J10=1, then offset (0,-8) and enter the word "TOTAL"... only thing is that I don't know how to do that.
Any help would be appreciated!
Thanks!
I don't know if this can be done via Excel formula, or VBA, but I have an if statement in one column that will return the number "1" if the condition is true.
I.e. J10 = 1 as C10 is true to the condition.
I'm importing the cell C10 so it's always changing, so a formula would be wiped out, however if J10 is true (and equal to "1"), I'd like C10 to read "TOTAL".
Hopefully this makes sense. I was thinking of placing some sort of statement in column K (K10?) that if J10=1, then offset (0,-8) and enter the word "TOTAL"... only thing is that I don't know how to do that.
Any help would be appreciated!
Thanks!