If/then question
Closed
Lmetz0804
-
Nov 21, 2016 at 11:45 AM
yg_be Posts 23471 Registration date Sunday June 8, 2008 Status Contributor Last seen February 15, 2025 - Nov 21, 2016 at 05:08 PM
yg_be Posts 23471 Registration date Sunday June 8, 2008 Status Contributor Last seen February 15, 2025 - Nov 21, 2016 at 05:08 PM
Related:
- If/then question
- How can i recover my yahoo account with security question - Guide
- Google recovery password security question - Guide
- Mom’s secret question - Guide
- How to type question mark on laptop keyboard - Guide
- How to do upside down question mark on mac - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 21, 2016 at 11:51 AM
Nov 21, 2016 at 11:51 AM
Hi Lmetz0804,
Here you go:
=if(B1="","",B1)
Best regards,
Trowa
Here you go:
=if(B1="","",B1)
Best regards,
Trowa
Nov 21, 2016 at 12:02 PM
Nov 21, 2016 at 12:22 PM
Nov 21, 2016 at 03:39 PM
Nov 21, 2016 at 04:14 PM
This formula does almost exactly what I need:
=IF('Project Schedule'!H7="","",'Project Schedule'!H7)
My only challenge is that sometimes the text, "1/0/00" appears in 'Project Schedule'!H7. I want excel to return nothing if that text is there.
So in short I want excel to:
1) return nothing if no text is in 'Project Schedule'!H7
2) return nothing if the text "1/0/00" appears in 'Project Schedule'!H7
3) return the exact contents if any other text is in 'Project Schedule'!H7
The formula above does all but number 2.
Thanks!
Nov 21, 2016 at 04:49 PM
(corrected : no double ")