bdterryCopper ContributorMay 21, 2019SolvedHelp 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 ...Show MoreRich99May 21, 2019Hi bdterry , This should do it =IF(AND(A2>=1,A2<=10),1.5,0)
bdterryCopper Contributor to Rich99May 21, 2019Rich99 yip thanks, got it sorted finally and then your message came through... spot on!
bdterryCopper Contributor to Rich99May 21, 2019Rich99 yip thanks, got it sorted finally and then your message came through... spot on!
