IF Statement
=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
|