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.
View best response
Hi @bdterry , This should do it =IF(AND(A2>=1,A2<=10),1.5,0)
@Rich99 yip thanks, got it sorted finally and then your message came through... spot on!