| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statment | Excel Discussion (Misc queries) | |||
| if statment | Excel Worksheet Functions | |||
| ADO SQL statment | Excel Programming | |||
| If statment | Excel Worksheet Functions | |||
| if statment | Excel Programming | |||
Hybrid Mode
