Forum Discussion

bdterry's avatar
bdterry
Copper Contributor
May 21, 2019
Solved

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!

 

2 Replies

  • Rich99's avatar
    Rich99
    Iron Contributor

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

    • bdterry's avatar
      bdterry
      Copper Contributor

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

       

Resources