| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function difficulties
Hello all,
I am trying to do an if statement. If cell A1 is greater than ten, then I want to divide it by ten and round down to the nearest whole number. If A1 is less than ten, I want to leave it by itself. I tried this: =IF(A110,(ROUNDDOWN(A1/10,0)),U2), but it is not working for some of the cells that are less than 10. Any suggestions? Thanks in advance. Mike |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if function difficulties
=IF(A110,ROUNDDOWN(A1/10,0),A1)
" wrote: Hello all, I am trying to do an if statement. If cell A1 is greater than ten, then I want to divide it by ten and round down to the nearest whole number. If A1 is less than ten, I want to leave it by itself. I tried this: =IF(A110,(ROUNDDOWN(A1/10,0)),U2), but it is not working for some of the cells that are less than 10. Any suggestions? Thanks in advance. Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keystroke Difficulties | Excel Discussion (Misc queries) | |||
| Difficulties with HYPERLINK | Excel Discussion (Misc queries) | |||
| difficulties | Excel Discussion (Misc queries) | |||
| totaling difficulties | Excel Worksheet Functions | |||
| Difficulties with COUNTIF. | Excel Worksheet Functions | |||
Linear Mode
