Previous Topic Next Topic

Formula to show a value in a cell if another cell has a value

Closed
johndeliu Posts 3 Registration date Monday 2 September 2013 Status Member Last seen 2 September 2013 - 2 Sep 2013 à 01:24
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 2 Sep 2013 à 03:27
Hi ............

Sheet 1 - shows a value of "Y" in A5
Sheet 1 - shows a date value in A1
Sheet 2 - A1 destination cell

"Sheet 2 A1" needs to show the date value in "Sheet 1 A1" if a "Y" is present in "Sheet 1 A5"

So basically, I need the date value in "Sheet 1 A1" to show in "sheet 2 A1" if a "Y" is present in "sheet 1 A5", and if no value in "sheet 1 A5" then cell shows "nothing"

Thanks Guys ...............
Related:

2 responses

Réponse 1 / 2
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
2 Sep 2013 à 01:33
=IF(Sheet1!A5="y",Sheet1!A1,"")

this formula is typoed in A1 sheet2.

probably date may be in number . format it as date.
johndeliu Posts 3 Registration date Monday 2 September 2013 Status Member Last seen 2 September 2013
2 Sep 2013 à 01:47
Thanks a heap, will try
johndeliu Posts 3 Registration date Monday 2 September 2013 Status Member Last seen 2 September 2013
2 Sep 2013 à 02:08
didnt work for some reason !!!
Réponse 2 / 2
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
2 Sep 2013 à 03:27
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

Similar discussions

If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Convert number to spelling
Sukumar -
mrwagh85 -

28 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses