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

you forgot the second if

=if(c10 "","0",if(ROUND(C10*1.2/38,0)<1,1,ROUND(C10*1.2/38,0))


--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"billy_bags" <billybags@discussions.microsoft.com> wrote in message
news:EB1265B5-03AF-48E1-801D-A017D44FA8B2@microsoft.com...
> =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

"billy_bags" <billybags@discussions.microsoft.com> wrote in message
news:EB1265B5-03AF-48E1-801D-A017D44FA8B2@microsoft.com...
> =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

Do you mean:
=IF(C10="","0",IF(ROUND(C10*1.2/38,0)<1,"1",ROUND(C10*1.2/38,0))) ?
--
David Biddulph

"Don Guillett" <dguillett1@austin.rr.com> wrote in message
news:OIi98s0gGHA.3956@TK2MSFTNGP02.phx.gbl...
SalesAid Software
> dguillett1@austin.rr.com
> "billy_bags" <billybags@discussions.microsoft.com> wrote in message
> news:EB1265B5-03AF-48E1-801D-A017D44FA8B2@microsoft.com...
>> =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

> you forgot the second if
>
> =if(c10 "","0",if(ROUND(C10*1.2/38,0)<1,1,ROUND(C10*1.2/38,0))

.... and you forgot the first =
:-)
--
David Biddulph

First of all, you left out the equal sign:
=If(C10="",

And, you have too many arguments for a single "IF" function.

Also, if you're dealing strictly in numbers, you should *not* enclose them
in quotes:
"1"
"0"
Since this will return text.

Anyway, try this:

=(C10>0)*(ROUND(C10*1.2/38,0)<1)*1+ROUND(C10*1.2/38,0)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"billy_bags" <billybags@discussions.microsoft.com> wrote in message
news:EB1265B5-03AF-48E1-801D-A017D44FA8B2@microsoft.com...
> =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

"David Biddulph" <david@biddulph.org.uk> wrote in message
news:XcadndeXbMnIpubZnZ2dnUVZ8sidnZ2d@bt.com...
> "Don Guillett" <dguillett1@austin.rr.com> wrote in message
> news:OIi98s0gGHA.3956@TK2MSFTNGP02.phx.gbl...
> SalesAid Software
> > dguillett1@austin.rr.com
> > "billy_bags" <billybags@discussions.microsoft.com> wrote in message
> > news:EB1265B5-03AF-48E1-801D-A017D44FA8B2@microsoft.com...
> >> =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
>
> > you forgot the second if
> >
> > =if(c10 "","0",if(ROUND(C10*1.2/38,0)<1,1,ROUND(C10*1.2/38,0))
>
> ... and you forgot the first =
> :-)

second actually <eb> :-)