ExcelBanter - if function difficulties

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - if function difficulties (https://www.excelbanter.com/excel-worksheet-functions/170968-if-function-difficulties.html)

[email protected]

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

Teethless mama

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

All times are GMT +1. The time now is 12:01 AM.