IF statement problem

[Kalabalana]

I have an if statement, and for either the true or false conditiona
statements, I would like to type some text and have a number displayed
This number is calculated by some formula.
For example, IF(MOD(ROW(),2)=0,"The current row; "ROW()" is even."
"This row is odd.")
But the above syntax is incorrect. What is the correct syntax t
perform this type of operation

 

[Bob Phillips]

=IF(MOD(ROW(),2)=0,"The current row; "&ROW()&" is even.","The current row;
"&ROW()&" is odd.")


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[JE McGimpsey]

One way:

=IF(MOD(ROW(),2)=0,"The current row; " & ROW() &" is even.",
"This row is odd.")


A variant:

="This row is " & IF(MOD(ROW(),2),"odd.","even.")

 

[crispbd]

=IF(MOD(ROW(),2)=0,"The current row " & ROW() & " is even.", "This ro
is odd."

 

[Kalabalana]

excellent thank you all for your hel