Forum Discussion
Solved
Function IF
Hello, I need help with this function. I'm trying to relate the IF function to a list with VLOOKUP entries. I want to know if certain entries of certain words appear on the list. I tried this...
Hello,
Its doesn't work. My office is in Portuguese, we use ";" instead of ","
If i use =IF(C4="Travel","-5","0") it relates to entries only the C4 cell.
My objective is to detect if there is any "Travel" entries in C4:C999
Its doesn't work. My office is in Portuguese, we use ";" instead of ","
If i use =IF(C4="Travel","-5","0") it relates to entries only the C4 cell.
My objective is to detect if there is any "Travel" entries in C4:C999
=SE(CONTAR.SE(C4:C999;"Travel")>0;"-5";"0") Portugal
=SE(CONT.SE(C4:C999;"Travel")>0;"-5";"0") Brasil
=SE(CONT.SE(C4:C999;"Travel")>0;"-5";"0") Brasil