IF Statement

[Guest]

How can I type a formula for the following:

If the value in cell b4 < 10, round the figure to 1 digit; if the value in
cell b4 is 10 or greater round to 0 digits.

Thank you,

 

[Dave Peterson]

=if(b4<10,round(b4,1),round(b4,0))

How can I type a formula for the following:

If the value in cell b4 < 10, round the figure to 1 digit; if the value in
cell b4 is 10 or greater round to 0 digits.

Thank you,

 

[Guest]

Thanks - it worked perfectly!
--
Sue

=if(b4<10,round(b4,1),round(b4,0))

 

[fanpages]

How can I type a formula for the following:

If the value in cell b4 < 10, round the figure to 1 digit; if the value in
cell b4 is 10 or greater round to 0 digits.

Thank you,

Hi Sue,

Place this formula in any cell other than [B4]:

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

BFN,

fp.