Can I use an IF ELSE statment

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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