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

Neater "=if "transaction
 

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

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

Neater "=if "transaction
 

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

Neater "=if "transaction
 

"Don Guillett" wrote in message
...
SalesAid Software

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

Neater "=if "transaction
 

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:

=(C100)*(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" wrote in message
...
=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

Neater "=if "transaction
 

"David Biddulph" wrote in message
...
"Don Guillett" wrote in message
...
SalesAid Software

"billy_bags" wrote in message
...
=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 :-)