Data validation with multiple rules

Hi,
I can't seem to figure out how to make a custom data validation work for multiple rules... Hoping you lovely people could help me figure out where I'm going wrong?!

I'm creating a spreadsheet for data input and need to make sure that the numbers going in a range of cells (B6-B36) are only whole numbers equal to, or greater than, zero (no negative numbers) with a maximum of 1 decimal point.

I've tried breaking down the rules and come up with this: =AND(ROUND(B6,1),MOD(B6,1)=0,B6>0)
But it didn't work...


Your help is much appreciated!!

Maybe this...

=AND(B6>=0,TRUNC(B6,1)=B6)

I interpret this:

Originally Posted by Rockguts

equal to, or greater than, zero

To mean: >=0

In your formula you have: >0

You're welcome. Thanks for the feedback!

Originally Posted by peterrc

Can you not just format the cells in that column to number with one decimal place?

That would limit the DISPLAYED value to 1 decimal place but that doesn't stop a user from entering a number with more decimal places which would be the true underlying value of the cell.