I need to create a formula IF with dates and 2 variables
Closed
adrianmty
-
14 Jul 2017 à 20:18
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 15 Jul 2017 à 08:53
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 15 Jul 2017 à 08:53
Related:
- I need to create a formula IF with dates and 2 variables
- Tentacle locker 2 - Download - Adult games
- My cute roommate 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- Need for speed underground 2 apk - Download - Racing
- Logitech formula vibration feedback wheel driver - Download - Drivers
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
15 Jul 2017 à 08:53
15 Jul 2017 à 08:53
adrianmty, Good morning.
Suppose:
A2 --> Cell with number
B2 --> DATE
C2 --> Result --> Formula
Try to use it:
C2 --> =IF(AND(A2>0,B2<=TODAY()-30), "SELL", "")
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Suppose:
A2 --> Cell with number
B2 --> DATE
C2 --> Result --> Formula
Try to use it:
C2 --> =IF(AND(A2>0,B2<=TODAY()-30), "SELL", "")
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
