Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF statement problem
I have an if statement, and for either the true or false conditional 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 to perform this type of operation? -- Kalabalana ------------------------------------------------------------------------ Kalabalana's Profile: http://www.excelforum.com/member.php...o&userid=11433 View this thread: http://www.excelforum.com/showthread...hreadid=314582 |
#2
|
|||
|
|||
=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) "Kalabalana" wrote in message ... I have an if statement, and for either the true or false conditional 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 to perform this type of operation? -- Kalabalana ------------------------------------------------------------------------ Kalabalana's Profile: http://www.excelforum.com/member.php...o&userid=11433 View this thread: http://www.excelforum.com/showthread...hreadid=314582 |
#3
|
|||
|
|||
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.") In article , Kalabalana wrote: I have an if statement, and for either the true or false conditional 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 to perform this type of operation? |
#4
|
|||
|
|||
=IF(MOD(ROW(),2)=0,"The current row " & ROW() & " is even.", "This row is odd.") -- crispbd ------------------------------------------------------------------------ crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880 View this thread: http://www.excelforum.com/showthread...hreadid=314582 |
#5
|
|||
|
|||
excellent thank you all for your help -- Kalabalana ------------------------------------------------------------------------ Kalabalana's Profile: http://www.excelforum.com/member.php...o&userid=11433 View this thread: http://www.excelforum.com/showthread...hreadid=314582 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Hyperlink to word document problem | Links and Linking in Excel | |||
Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
label problem | Excel Worksheet Functions | |||
If statement needed | Excel Worksheet Functions |