IF Statement: How can I write an IF statement for the following:

[Sue]

How can I write an IF statement for the following:

If the value in cell b4 < 10, round that figure to 1 decimal place.

If the value in cell b4 => 10, round that figure to 0 decimal place.

Thanks,
--
Sue

[Elkar]

Try this:

=IF(B4<10,ROUND(B4,1),ROUND(B4,0))

HTH,
Elkar

"Sue" wrote:

> How can I write an IF statement for the following:
>
> If the value in cell b4 < 10, round that figure to 1 decimal place.
>
> If the value in cell b4 => 10, round that figure to 0 decimal place.
>
> Thanks,
> --
> Sue

[CLR]

=IF(B4<10,ROUND(B4,1),IF(B4>=10,ROUND(B4,0),""))

Vaya con Dios,
Chuck, CABGx3



"Sue" wrote:

> How can I write an IF statement for the following:
>
> If the value in cell b4 < 10, round that figure to 1 decimal place.
>
> If the value in cell b4 => 10, round that figure to 0 decimal place.
>
> Thanks,
> --
> Sue

[Gary''s Student]

Use:


=IF(B4<10,ROUND(B4,1),ROUND(B4,0))

--
Gary's Student


"Sue" wrote:

> How can I write an IF statement for the following:
>
> If the value in cell b4 < 10, round that figure to 1 decimal place.
>
> If the value in cell b4 => 10, round that figure to 0 decimal place.
>
> Thanks,
> --
> Sue