Help with IF function

[bdterry]

I have hit a brain block, I should be able to do this but I can't!

I am calculating a formula where IF the cell = the value of any number from 1 through to 10, then return 1.5, otherwise return a 0

If someone can point me in the right direction that would be great.

Thanks!

[#2 · Accepted solution]

Hi @bdterry , This should do it  =IF(AND(A2>=1,A2<=10),1.5,0)

[#3]

@Rich99  yip thanks, got it sorted finally and then your message came through... spot on!