If/then question
Closed
Lmetz0804
-
Nov 21, 2016 at 11:45 AM
yg_be Posts 23541 Registration date Sunday June 8, 2008 Status Contributor Last seen June 6, 2025 - Nov 21, 2016 at 05:08 PM
yg_be Posts 23541 Registration date Sunday June 8, 2008 Status Contributor Last seen June 6, 2025 - Nov 21, 2016 at 05:08 PM
Related:
- If/then question
- Gmail security question - Guide
- How can i recover my yahoo account with security question - Guide
- What is your mother maiden name security question - Guide
- How to do upside down question mark on mac - Guide
- I forgot my yahoo security question - Yahoo Mail Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
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 ")