Forum Discussion
Cindy Dillard
Sep 15, 2018Copper Contributor
I need Formula help....
I and trying to create a formula by looking at two different cells, and based on the number there, putting the answer into a different cell.
Seems pretty simple to me, but just can't make it work.
Here is what I have right now.
=IF(E18>=1 & E19>=4,"You got a block!!"," ") this one is producing the correct answer, but I don't think it is right since the second one is putting in the true answer, but it is not correct.
=IF(E18>=2 & E19>=8,"You got TWO blocks!!"," ")
Current information in cells are: E18 is 2 and E19 is 4.
2 Replies
- Lorenzo KimBronze Contributor
any feedback?
- Lorenzo KimBronze Contributor
=IF(E18>=2 & E19>=8,"You got TWO blocks!!"," ")
TRY:
=IF(AND(E18>=2,E19>=8),"You got TWO blocks!!"," ")
HTH