IF Statement

S

Sue

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,
 
D

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,
Click to expand...
 
F

fanpages

Sue said:
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,
Click to expand...


Hi Sue,

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

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

BFN,

fp.
 
Top