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 January 16, 2023 - Dec 13, 2021 at 11:26 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Dec 13, 2021 at 11:26 AM
Related:
- If cell contains (multiple text criteria) then return (corresponding text criteria)
- Excel - IF function with multiple words ✓ - Excel Forum
- How to re/name a cell if another cell contains X ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- If cell contains specific text then return value in another cell vba ✓ - Excel Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
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