If statement for rows??

[kceesay]

Hi everyone,

I am trying to build an IF statement to read each row for values containing "rp" and replace the row above with "Tree" using the multi row formula. I keep running into issues any idea how I can troubleshoot?

IF (Contains([F2], "rp")) = "TRUE"
THEN[Row-1:F2] = "Tree"
ELSE [F2]

[Felipe_Ribeir0 · Accepted solution]

Hi @kceesay 

Try this formula

IF Contains([Row+1:F2], "rp") then
"Tree"
ELSE [F2]
ENDIF

[DataNath]

Hey @kceesay is this what you're looking for? Just need to work the other way around and look downwards if so:

[ShankerV]

Hi @kceesay 

Please use the below IF statement.

IF (Contains([Row +1:F2], "rp"))

THEN "Tree"
ELSE [F2]

ENDIF

IF Condition is True 

THEN statement gets executed

ELSE ie. False statement gets executed.

ENDIF is necessary to end the condition.

Many thanks

Shanker V

[kceesay]

Yes this worked thank you!

[kceesay]

Yes, you're right I should've been looking down a row vs up one thank you!