Forum Discussion
bdterry
May 21, 2019Copper Contributor
Help with IF function
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!
Hi bdterry , This should do it =IF(AND(A2>=1,A2<=10),1.5,0)