If reads "open" in other cell, returns "ABC"
Closed
Killienne
-
Jun 3, 2010 at 04:06 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 3, 2010 at 04:26 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 3, 2010 at 04:26 PM
Related:
- If reads "open" in other cell, returns "ABC"
- Based on the values in cells b77 b81 what function can automatically return the value in cell c77 ✓ - Excel Forum
- Conditional formatting if cell contains text - Excel Forum
- How to delete cell in word - Guide
- How to use conditional format based on text? ✓ - Excel Forum
- Excel multiple lines in one cell - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 3, 2010 at 04:26 PM
Jun 3, 2010 at 04:26 PM
You need to provide more info about employee etc
but basic idea would be in cell M, you can have
=IF(H2="open", B2, "")
basically says that
if H2 is equal to open then show me value in B2
AND
if H2 is any thing other than Open, then show "" (blank)
but basic idea would be in cell M, you can have
=IF(H2="open", B2, "")
basically says that
if H2 is equal to open then show me value in B2
AND
if H2 is any thing other than Open, then show "" (blank)
