Miguelluis
New Member
- Joined
- Jan 29, 2013
- Messages
- 45
Hi,
I'm trying to set up a holiday spreadsheet where I want it to add 1 if a cell contains the text "AL" and add 0.5 if the cell contains the text HD.
I <gs id="ee443cc7-e45f-4547-9ea8-7dac38435b9a" ginger_software_uiphraseguid="fb07d914-4a5e-40c1-b1b3-a34425f7f08b" class="GINGER_SOFTWARE_mark">sounds</gs> so <gs id="8c79adbb-d5c4-4c1f-ae6b-a16cb803cf08" ginger_software_uiphraseguid="fb07d914-4a5e-40c1-b1b3-a34425f7f08b" class="GINGER_SOFTWARE_mark">simple but</gs> I can't find a formula that works.
Can you help?
Kind regards
Miguel
I'm trying to set up a holiday spreadsheet where I want it to add 1 if a cell contains the text "AL" and add 0.5 if the cell contains the text HD.
I <gs id="ee443cc7-e45f-4547-9ea8-7dac38435b9a" ginger_software_uiphraseguid="fb07d914-4a5e-40c1-b1b3-a34425f7f08b" class="GINGER_SOFTWARE_mark">sounds</gs> so <gs id="8c79adbb-d5c4-4c1f-ae6b-a16cb803cf08" ginger_software_uiphraseguid="fb07d914-4a5e-40c1-b1b3-a34425f7f08b" class="GINGER_SOFTWARE_mark">simple but</gs> I can't find a formula that works.
Can you help?
Kind regards
Miguel