IF formula with multiple conditions

[PFERNA]

Hello everyone,

As the title of the thread says, I need help with having multiple conditions in an IF formula.

IF Excel.jpg

Basically what I want is that when a cell in "Horas Trabalhadas" is "FOLGA" that it returns "FOLGA" in "Subsídio de Refeição" instead of "SIM" or "NÃO".

I've tried using the OR function but I can't seem to get there. May you give me some help please?

Thanks!

[asar_k]

Hi,

I think you are trying to evaluate it like this:
If the time is >=5, give me a "SIM", if it is <5, give me a "NAO", and if its "FOLGA", give me "FOLGA".

If so, I have found this formula helpful:
=IF(C15="FOLGA","FOLGA",IF(C15>=TIME(5,0,0),"SIM","NAO"))

You may take your own cell references instead of mine.

And let me know if I've been correct in my understanding of the problem.

Regards
Asar

[etaf]

=if( F2 = "FOLGA", "Subsídio de Refeição", --- not sure how you get "SIM" or "NÃO". into the cell

=if( F2 = "FOLGA", "Subsídio de Refeição", then put the formula you have here ie IF( F2>=time....... ) )


a spreadsheet rather than the image would be much better help here

[PFERNA]

Hi,

I think you are trying to evaluate it like this:
If the time is >=5, give me a "SIM", if it is <5, give me a "NAO", and if its "FOLGA", give me "FOLGA".

If so, I have found this formula helpful:
=IF(C15="FOLGA","FOLGA",IF(C15>=TIME(5,0,0),"SIM","NAO"))

You may take your own cell references instead of mine.

And let me know if I've been correct in my understanding of the problem.

Regards
Asar

Thank you very much asar_k, that turned out perfectly :D

[asar_k]

Great!! My pleasure!
You may close the thread if you please.

[FDibbins]

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.