I have a cell I'd like to display two digits, regardless of the number. So if it's less than 10, I'd like it to display 7.9 for insteance. But if it's 11, I don't want it to say 11.6, I don't want it to say 11.6, but rather 12
Is this possible?
I have a cell I'd like to display two digits, regardless of the number. So if it's less than 10, I'd like it to display 7.9 for insteance. But if it's 11, I don't want it to say 11.6, I don't want it to say 11.6, but rather 12
Is this possible?
I am not sure what rules are you trying to apply but maybe something like:
=IF(A1<10,7.9,ROUNDUP(A1,0)) or =IF(A1<10,7.9,INT(A1)) or =IF(A1<10,7.9,INT(A1)+1)
No it's not that, it's that the cell is big enough for two digits (and a decimal point if need be). I'm interested in the tenths place when number is low but not when it's high. Right now I have it to display one decimal place but when it's over 10 it just shows ### because the length of the number is too long. So I want it to show:
0.4 or
4.8 or
8.1 or
9.9 or
10 or
11 or
13 or
14
Try:
=IF(A1<10,ROUND(A1,1),INT(A1))
Perhaps a custom cell format of
[<10]0.0;0
Don
Please remember to mark your thread 'Solved' when appropriate.
Attach a sample workbook with few examples Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks