IF CELL A1 HAVE DATA IN COPY DATE IN B2
Solved/Closed
Related:
- Insert the current date and time in cell a1
- Where is the insert key - Guide
- Popcorn time apk - Download - Movies, series and TV
- Insert check mark in word - Guide
- How to insert at the rate in laptop - Guide
- Based on the cell values in cells b77 ✓ - Excel Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
15 May 2010 à 08:48
15 May 2010 à 08:48
Write this in B2
=IF(OR(A1=1, A1=2, A1=3), TODAY(),"")
in B1 write this
=IF(OR(A1=1, A1=2, A1=3, A1=""), "", TODAY())
You would have to format the cell b1, b2 as date, else it will show you some numbers
having said that I think you meant to say if there is data in A1 then show date in b2 and if there is no data in a1 then show date in b1. In that case
Write this in B2
=IF(A1 <>"", TODAY(),"")
in B1 write this
=IF A1="", "", TODAY())
=IF(OR(A1=1, A1=2, A1=3), TODAY(),"")
in B1 write this
=IF(OR(A1=1, A1=2, A1=3, A1=""), "", TODAY())
You would have to format the cell b1, b2 as date, else it will show you some numbers
having said that I think you meant to say if there is data in A1 then show date in b2 and if there is no data in a1 then show date in b1. In that case
Write this in B2
=IF(A1 <>"", TODAY(),"")
in B1 write this
=IF A1="", "", TODAY())
