software

How can I write an IF statement for the following:

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

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

Thanks,
--
Sue

Try this:

=IF(B4lt;10,ROUND(B4,1),ROUND(B4,0))

HTH,
Elkar

quot;Suequot; wrote:

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

=IF(B4lt;10,ROUND(B4,1),IF(B4gt;=10,ROUND(B4,0),quot;quot;))

Vaya con Dios,
Chuck, CABGx3
quot;Suequot; wrote:

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

Use:=IF(B4lt;10,ROUND(B4,1),ROUND(B4,0))

--
Gary's Studentquot;Suequot; wrote:

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