PC Review


Reply
Thread Tools Rate Thread

Can I use an IF ELSE statment

 
 
Eidink
Guest
Posts: n/a
 
      2nd Mar 2010
Is it possible to use this type of syntax in Excel - eg
IF(c6<8,c6)ELSE MROUND(c6,0.25) What am I doing incorrectly?
Thanks
Eidin
 
Reply With Quote
 
 
 
 
Rick Rothstein
Guest
Posts: n/a
 
      2nd Mar 2010
The IF function has three parts to it... the logical test, the true result
and the false result. The false result part is equivalent to your ELSE
attempt. Try writing your formula this way...

=IF(C6<8,C6,MROUND(C6,0.25))

--
Rick (MVP - Excel)


"Eidink" <(E-Mail Removed)> wrote in message
news:AFEB1B9D-70D0-47B8-9E78-(E-Mail Removed)...
> Is it possible to use this type of syntax in Excel - eg
> IF(c6<8,c6)ELSE MROUND(c6,0.25) What am I doing incorrectly?
> Thanks
> Eidin


 
Reply With Quote
 
Don Guillett
Guest
Posts: n/a
 
      2nd Mar 2010
Have you looked in the help index for IF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Eidink" <(E-Mail Removed)> wrote in message
news:AFEB1B9D-70D0-47B8-9E78-(E-Mail Removed)...
> Is it possible to use this type of syntax in Excel - eg
> IF(c6<8,c6)ELSE MROUND(c6,0.25) What am I doing incorrectly?
> Thanks
> Eidin


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
if statment =?Utf-8?B?RHJlYW1zdGFyXzE5NjE=?= Microsoft Excel Worksheet Functions 5 17th Apr 2007 01:30 PM
ADO SQL statment =?Utf-8?B?SlQ=?= Microsoft Excel Programming 4 7th Feb 2007 11:15 AM
and or statment =?Utf-8?B?SlJT?= Microsoft Access Queries 1 25th Jan 2007 04:47 AM
SQL statment Tom Microsoft Access 0 24th May 2006 03:02 AM
SQL Statment Dib Microsoft Access ADP SQL Server 2 28th Jun 2004 05:33 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:42 PM.