If cell contains multiple text how to add other cell value?
Solved/Closed
Iza
-
Dec 3, 2021 at 05:04 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 13, 2021 at 11:26 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 13, 2021 at 11:26 AM
Related:
- If cell contains multiple text then return value
- If cell contains (multiple text criteria) then return (corresponding text criteria) - Best answers
- If cell contains text then return value multiple conditions - Best answers
- If a cell has text then return value ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Excel: If Date =, then enter a value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 13, 2021 at 11:26 AM
Dec 13, 2021 at 11:26 AM
Hi Iza,
Give the following formula a try:
=IF(C1="A",A1*-1,IF(C1="B",B1,IF(C1="AB",B1/2,"")))
Best regards,
Trowa
Give the following formula a try:
=IF(C1="A",A1*-1,IF(C1="B",B1,IF(C1="AB",B1/2,"")))
Best regards,
Trowa