Need Help! I need a simple solution to a simple problem but can't remember
how to resolve this formula (i've not done formulas for 3 years- yikes!)
Basically I need to identify if a person is "hourly", they receive "8" hours
of vacation, if they are "salary", then they receive 16 hours of vacation. I
don't know what would be the best way to resolve this. I used
=if(A1="hourly",8,0).... but I could not remember how to check the cell for
more than one "text" and give me a result based on the cell contents.
A B
1 hourly 8 (result)
2 salary 16 (result)

Can anyone help me with this thing?