| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Neater "=if "transaction
=IF(ROUND(C10*1.2/38,0)<1,"1",ROUND(C10*1.2/38,0))
However, if cell c10 has no figure in it at all I want it to show "0" I have tried =if(c10 "","0",ROUND(C10*1.2/38,0)<1,"1",ROUND(C10*1.2/38,0)) but the formula error box appears Can some kind soul enlighten me and Is there a neater way that I can express this formula Thanks Bill |
Threaded Mode
