LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Kalabalana
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Row Autofit problem Excel 2003 Matthias Klaey Excel Discussion (Misc queries) 0 January 19th 05 05:33 PM
Hyperlink to word document problem JS Links and Linking in Excel 0 December 8th 04 10:54 PM
Paper Tray selection Problem, Michael Hoffmann Excel Discussion (Misc queries) 4 December 3rd 04 09:08 PM
label problem Raven Maniac Excel Worksheet Functions 5 November 10th 04 10:10 PM
If statement needed Patsy Excel Worksheet Functions 1 November 4th 04 03:48 PM


All times are GMT +1. The time now is 04:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"