IF CELL A1 HAVE DATA IN COPY DATE IN B2
Solved/Closed
Related:
- Insert the current date and time in cell a1
- Popcorn time download - Download - Movies, series and TV
- Facebook id verification time - Guide
- The system time is invalid hp ✓ - CPU & Desktop Forum
- Insert check mark in word - Guide
- Lava a1 reset code ✓ - Phones, PDA & GPS Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 15, 2010 at 08:48 AM
May 15, 2010 at 08:48 AM
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())
