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 Contributor Last seen December 27, 2022 - Dec 13, 2021 at 11:26 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Dec 13, 2021 at 11:26 AM
Related:
- If cell contains text then return value multiple conditions
- If cell contains multiple text then return value - Best answers
- If cell contains (multiple text criteria) then return (corresponding text criteria) - Best answers
- Excel - IF function with multiple words ✓ - Excel Forum
- Conditional formatting if cell contains text ✓ - Excel Forum
- If cell contains any text then return value ✓ - Excel Forum
- What function can automatically return the value in cell c77 - Excel Forum
- Excel if cell contains date then return value - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
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