ExcelBanter - Can I use an IF ELSE statment

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Can I use an IF ELSE statment (https://www.excelbanter.com/excel-programming/440135-can-i-use-if-else-statment.html)

Eidink

Can I use an IF ELSE statment

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

Rick Rothstein

Can I use an IF ELSE statment

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" wrote in message
...
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

Don Guillett[_2_]

Can I use an IF ELSE statment

Have you looked in the help index for IF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eidink" wrote in message
...
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

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