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
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- If cell contains text then return value in another cell ✓ - Excel Forum
- If a cell contains any text then add a value ✓ - Excel Forum
- Run macro when cell value changes - Guide
- Excel formula to subtract one cell from another - 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