Formula to show a value in a cell if another cell has a value
Closed
johndeliu
Posts
3
Registration date
Monday September 2, 2013
Status
Member
Last seen
September 2, 2013
-
Sep 2, 2013 at 01:24 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 2, 2013 at 03:27 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 2, 2013 at 03:27 AM
Related:
- Formula to show a value in a cell if another cell has a value
- Count if cell contains number - Excel Forum
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- An example of a cell is a blank cell ✓ - Programming Forum
- Conditional formatting if cell contains text - Excel Forum
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 2, 2013 at 01:33 AM
Sep 2, 2013 at 01:33 AM
=IF(Sheet1!A5="y",Sheet1!A1,"")
this formula is typoed in A1 sheet2.
probably date may be in number . format it as date.
this formula is typoed in A1 sheet2.
probably date may be in number . format it as date.
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 2, 2013 at 03:27 AM
Sep 2, 2013 at 03:27 AM
whay do you mean "did not work" it worked in my co;mputere
what did yyou do stelp by step and then what did you get in A1 of sheest2
explain fullly then only newsgsroup can help
what did yyou do stelp by step and then what did you get in A1 of sheest2
explain fullly then only newsgsroup can help
Sep 2, 2013 at 01:47 AM
Sep 2, 2013 at 02:08 AM