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
- If cell contains date then return value - Excel Forum
- If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum
- Excel send value to another cell - Guide
- Conditional formatting if cell contains text - Excel Forum
- Number to words in excel formula - Guide
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