user7933994
Reputation:
In Excel i want to fix this code as it seems not working propaply
i am trying to figure out how to use IF AND ,, or IF OR
but i need little help here
the value must be in A1:A20 ,, B1:B20
=IF(A1:A20=6050 and B1:B20 =3011 ;"Value achived";"try Again")
Upvotes: 0
Views: 11
Answers (1)
shakespeare
Reputation: 136
it work like this IF(AND(log1;log2....
=IF(AND(A1:A20=6050;B1:B20=3011);"Value achived";"try Again")
this is an example
Upvotes: 1
Related Questions
- Anyone know why it gives me error or how solve this?
- I am trying to make this code work but failing due to End With
- How do I code better way instead of coding like this VBA
- How to fix the error in the excel vba code?
- How can I do this in excel
- Error in the VBA code
- I have written the code below in VBA (Excel), but it gives me the wrong result?
- Microsoft Excel formula doesn´t work
- Cannot get this Function to work it is something wrong with the Loop I think
- excel vba please check this code that it is not working