If and.....

[MaryEsther04]

If number is less than 10 round off to 3 sig.numbers and If my number is greater than 10 round off to 2 sig.numbers. This is part of the answer but need help for the second part?

=IF(cell>10,round(cell,3))

 

[Jonmo1]

Welcome to the board..

Try

=ROUND(cell,IF(cell>10,2,3))

 

[MaryEsther04]

OK But if the number is less than one must say <1
Example:
0.28597 = <1 less than 1
2.8597 = 2.9 2 sigs numbers
28.597 = 28.6 3 sigs numbers

 

[Jonmo1]

Try
=IF(A1<1,"<1 less than 1",ROUND(A1,1))

Excel Workbook
	A	B
1	0.28597
2	2.8597	2.9
3	28.597	28.6
Sheet1

 

[MaryEsther04]

Ok, but can be combine in One formula?

 

[Jonmo1]

That is one formula...

 

[Rick Rothstein]

If your numbers are always less then 100, you could Custom Format the cells with the numbers using this...

[<1]"less than 1";0.0

and not use any formulas at all.